Fix Excel Workbook Links That Break on SharePoint
Question details
Find out why Excel workbook links change to SharePoint URLs and troubleshoot links that no longer update.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- A user saves linked workbooks to OneDrive or SharePoint and reopens them.
- Observed behavior
- Local workbook references are converted to SharePoint URLs, and some links stop updating or show update warnings.
Identify the destination workbook and each source workbook it references. Sign in to the relevant Microsoft 365 account and check that the source files open from SharePoint.
Compare the affected links and verify source access
Use this approach to determine whether a link points to the correct SharePoint location and whether users can open the source.
Open the destination workbook in desktop Excel. On the Data tab, select Workbook Links or Edit Links, depending on your Excel version, and review the listed source paths.
Compare an affected link with a working SharePoint link, paying attention to the site, document library, folders, and file name. Copy an affected path for review, removing any sensitive information before sharing it.
Open the source workbook from its SharePoint document library. Ask other affected users to open it with their own accounts to confirm that they have access.
Return to the destination workbook and use Update values in the Workbook Links pane, or Update Values in the Edit Links dialog, to check whether the link updates.

Change a broken workbook link to the correct source
Use this when the link points to an old or incorrect workbook location.
Work with Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files and move existing documents into your workflow; WPS does not fix Microsoft Excel's SharePoint link conversion.

Frequently Asked Questions
Why did Excel change my local workbook link to a SharePoint URL?
Excel may convert the reference based on the workbook's file and folder location after it is saved to SharePoint or OneDrive. Compare the source shown under Data > Workbook Links or Edit Links with the actual source file location.
How can I tell whether a broken link is caused by permissions?
Open the source workbook from its SharePoint document library using the affected user's account. If the user cannot open it, check the file's sharing permissions before updating the link in Excel.
Where can I change the source of an Excel workbook link?
In desktop Excel, go to Data > Workbook Links or Data > Edit Links, select the source, and choose Change source. Select the correct workbook and update the link.
Can WPS Office fix Excel's SharePoint URL conversion?
No. WPS Office is an alternative for working with compatible Excel files, but it does not change how Microsoft Excel converts SharePoint links. Troubleshoot those links in Excel and SharePoint.




