Permission & Access Issues

Fix an Incorrect Sign-In URL for an Excel SharePoint Workbook

Jason MillerJason Miller Nov 22, 2026 868 views

Question details

Identify why an Excel workbook stored in SharePoint requests sign-in at an incorrect URL after content is enabled.

Product
Microsoft Excel and SharePoint
Device & OS
not provided
Scenario
A SharePoint workbook contains an external link to another workbook on a Windows file share.
Observed behavior
After Enable Content is selected, the sign-in prompt combines the SharePoint tenant URL with the shared-drive path, even though Edit Links shows the expected source location.
Before you start

Identify the affected workbook and the expected location of its linked source workbook. Do not enter credentials into a prompt with an unexpected URL; capture the URL with sensitive information removed if you need to share it for troubleshooting.

Solution 1Recommended

Inspect the Workbook’s External Links and Connections

Use this method to find the link or connection associated with the incorrect sign-in prompt.

1
Open the affected workbook

Open the workbook from SharePoint in Excel and note when the sign-in prompt appears after you select Enable Content.

2
Review external links

On the Data tab, open Workbook Links or Edit Links, depending on your Excel version. Identify links to other workbooks, especially those created with Paste Special > Paste Link.

3
Check data connections

Select Data > Queries & Connections and inspect the listed queries and connections for references to the shared-drive workbook.

4
Verify source access

Open the linked source workbook directly from its expected shared-drive location. Confirm that the affected user can access the file and that the location matches the source shown in Excel.

Inspect the Workbook’s External Links and Connections
A correct source path may not explain the prompt: The reported workbook showed the correct location in Edit Links even though the sign-in URL was incorrect. Continue with a comparison test if the source is accessible.
Free Microsoft Office alternative

Work with Excel Files in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing Excel files. It can help you transition to another spreadsheet app, but it does not fix Microsoft Excel’s SharePoint sign-in prompt.

Open and edit Microsoft Excel XLSX filesWork with spreadsheet formulas and linked data in a familiar interfaceUse a free, lightweight office suiteMove existing Office files into a familiar workspace
microsoft office alternative - wps office

Frequently Asked Questions

Where can I find links to other workbooks in Excel?

On the Data tab, select Workbook Links or Edit Links, depending on your Excel version. Look for references to the source workbook, including links created with Paste Special > Paste Link.

Why does the prompt show an incorrect URL when Edit Links shows the right path?

The reported issue can occur even when Edit Links displays the expected shared-drive location. Check Data > Queries & Connections as well, verify access to the source, and compare the affected workbook with a SharePoint-only test.

How can I tell whether the problem affects just one user?

Ask another authorized user to open the affected workbook and compare the result with the affected user’s experience. Also test a new linked workbook stored entirely in SharePoint.

Should I enter my password into the unexpected sign-in prompt?

Do not enter credentials when the URL is unexpected. Capture a screenshot with sensitive information removed and share it with your support team for review.

Will WPS Office fix the Excel SharePoint sign-in URL?

No. WPS Office is an alternative for working with Excel files, but it does not repair Microsoft Excel’s SharePoint authentication behavior. Check that any required external links and SharePoint features work for your files before switching.