Fix an Incorrect Sign-In URL for an Excel SharePoint Workbook
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.
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.
Inspect the Workbook’s External Links and Connections
Use this method to find the link or connection associated with the incorrect sign-in prompt.
Open the workbook from SharePoint in Excel and note when the sign-in prompt appears after you select Enable Content.
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.
Select Data > Queries & Connections and inspect the listed queries and connections for references to the shared-drive workbook.
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.

Compare the Affected Workbook with a SharePoint Test Workbook
Use a controlled test to determine whether the behavior is specific to a link, workbook, or user.
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.

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.




