Formula Errors

Fix Excel External Link Errors After Uploading to SharePoint Online

Muhammad TalhaMuhammad Talha Nov 20, 2026 869 views

Question details

The user needs to resolve external workbook link errors after uploading an Excel workbook to SharePoint Online.

Fix Excel External Link Errors After Uploading 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!.
Before you start

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.

Solution 1Recommended

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.

1
Check the affected formula

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.

2
Check the shared source

Open the source workbook from its SharePoint or OneDrive location and confirm that the intended users have permission to access it.

3
Update the link

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.

4
Test in the browser

Save the destination workbook, open it from SharePoint Online in Excel for the web, and check the affected cells again.

Check the source workbook and update the external link
Web limitations: A shared source location and correct permissions do not guarantee that every external link will work in Excel for the web. If the link works in desktop Excel but still fails in the browser, use a local-data workaround or investigate the web limitation.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet formulas and local dataUse a familiar interface for everyday spreadsheet tasksMove between compatible Office files with less disruption
microsoft office alternative - wps office

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.