SharePoint Document Issues

Fix Excel Workbook Links That Break on SharePoint

Steven ParkerSteven Parker Nov 14, 2026 870 views

Question details

Find out why Excel workbook links change to SharePoint URLs and troubleshoot links that no longer update.

Fix Excel Workbook Links That Break on SharePoint
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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the workbook links

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.

2
Compare the 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.

3
Test the source workbook

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.

4
Retest the link

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.

Compare the affected links and verify source access
Why the path changes: Excel may replace a local reference with a SharePoint URL based on where the workbook is stored. Comparing paths can help identify the issue, but there is no guaranteed way to control the URL format Excel creates.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet tools to work with workbook dataMove existing Office documents into a lightweight workspaceGet started free with an easy-to-use interface
microsoft office alternative - wps office

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.