Fix Excel External Links to SharePoint Workbooks Showing #REF!
Question details
Fix formulas that reference a workbook in another SharePoint document library and display #REF! errors.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- An Excel workbook references a source workbook stored in a separate SharePoint document library.
- Observed behavior
- Formulas show #REF! and the external link status is Not Found, even though the source workbook may open directly.
Check whether the error occurs in desktop Excel or Excel for the web, and confirm that you can open the source workbook with the account you use for SharePoint. Note the source workbook’s library, file name, and location before changing the link.
Rebuild the Link From Synchronized SharePoint Libraries
Use this approach when a SharePoint URL link reports Not Found but the source workbook is accessible.
Use the OneDrive sync client to make the libraries available locally, then create the reference in desktop Excel. Link behavior can vary between desktop Excel and Excel for the web.
In SharePoint, open each document library and select Sync. Follow the OneDrive prompts and wait for both workbooks to finish syncing.
Open the destination and source workbooks from their synchronized folders in desktop Excel.
In the destination workbook, select an affected cell and type =. Switch to the source workbook, select the required cell, and press Enter to create a new external reference.
Save both workbooks, close them, and reopen the destination workbook in desktop Excel. If prompted, enable or update the links and check whether the formula returns the expected value.

Check the Source Location and Update the Existing Link
Use this method to repair an existing link when the source file has moved or its recorded path is unavailable.
Work With Excel-Compatible Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open existing spreadsheets to make migration easier; WPS does not repair Microsoft Excel’s SharePoint link behavior.

Frequently Asked Questions
Why can I open the source workbook but still see Not Found in Excel?
Opening a file directly and resolving an external workbook link are different operations. The link may contain an unavailable path or behave differently in your Excel environment. In desktop Excel, check Data > Workbook Links or Data > Edit Links and review the recorded source.
How do I change the source of an external workbook link?
In desktop Excel, go to Data > Workbook Links or Data > Edit Links, select the affected link, and choose Change Source if available. Select the correct workbook and update the link.
Will the same link work in Excel for the web?
External-link behavior can differ between desktop Excel and Excel for the web. After repairing the link in desktop Excel, open the destination workbook in the web app and test whether the values update there.
What if the link is available but a formula still shows #REF!?
Select the affected cell and inspect its formula. A deleted or renamed sheet, cell, or range can leave an invalid reference even after the source workbook is found. Correct the reference or recreate it by selecting the intended source cell.
Do other users need access to both SharePoint libraries?
Users need access to the destination workbook and to the source workbook referenced by its formulas. Check each user’s SharePoint permissions and test the link from their Excel environment.




