Fix Excel External Link Errors After Uploading to SharePoint Online
Question details
The user needs to resolve external workbook link errors after uploading an Excel workbook to SharePoint Online.

- Product
- Microsoft Excel for the web and SharePoint Online
- Device & OS
- not provided
- Scenario
- A workbook containing formulas linked to another workbook is uploaded to SharePoint Online and opened in Excel for the web.
- Observed behavior
- One linked column displays the expected value, while another returns #REF!.
Open the source and destination workbooks in desktop Excel and check whether the affected formula already shows #REF! there. Confirm that you have access to the source workbook and note which cells and formulas are affected.
Check the source workbook and update the external link
Use this approach when the destination workbook should continue to pull data from the source workbook.
In desktop Excel, select a cell showing #REF! and inspect the formula bar. Compare its workbook, sheet, and cell references with a working formula; correct any invalid references.
Open the source workbook from its SharePoint or OneDrive location and confirm that the intended users have permission to access it.
In the destination workbook, open Data > Workbook Links or Data > Edit Links, depending on your Excel version. Select the source and use Change Source or Update Values as available.
Save the destination workbook, open it from SharePoint Online in Excel for the web, and check the affected cells again.

Replace external links with values or local data
Use this workaround when the uploaded workbook does not need to update automatically from the source.
Report a possible Excel for the web limitation
Use this option if valid links work in desktop Excel but continue to fail in Excel for the web.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. It does not fix Excel for the web or SharePoint service limitations.

Frequently Asked Questions
Why does one linked column work while another shows #REF!?
The formulas may reference different cells or contain an invalid sheet or range reference. In desktop Excel, select each cell and compare the formulas in the formula bar, then check that the referenced source still exists.
Where can I change the source of an Excel workbook link?
In desktop Excel, open Data > Workbook Links or Data > Edit Links, depending on your version. Select the source workbook and choose Change Source if the option is available.
Will putting the source workbook in SharePoint fix every external link?
Not necessarily. A supported shared location and access permissions are important, but Excel for the web may still have limitations with particular external links. Test the workbook in both desktop Excel and the browser.
How can I keep the displayed results without external links?
In desktop Excel, select the linked cells while they show the correct results, copy them, and use Home > Paste > Paste Values. The pasted results will no longer update from the source workbook.




