Fix Excel External Links That Change to #REF
Question details
Identify why Excel external links display #REF after a link-update choice and determine how to restore valid references.

- Product
- Microsoft Excel
- Device & OS
- Windows; version not provided
- Scenario
- Opening a workbook with external links in a different Windows or Office environment and choosing whether to update the links.
- Observed behavior
- External-link formulas may change to #REF, including after choosing not to update links.
Identify the source workbook or other data source used by the links, and check whether it is accessible. Note whether the error appears after selecting Update or Don't Update.
Check the link source and repair invalid references
Use this when the source file has moved, is unavailable, or contains changed references.
Open the affected workbook and go to Data > Workbook Links or Data > Edit Links, depending on your Excel version. Note the source paths and link status.
Open the source workbook from its current location and verify that the referenced sheet and cells still exist.
In Workbook Links or Edit Links, select the affected link and choose Change Source. Browse to the correct source file and confirm the selection.
Select a cell showing #REF and inspect its formula in the formula bar. Correct any invalid sheet or cell references, then save and reopen the workbook to test your update choice.

Compare the workbook and Excel environments
Use this to establish which update choice and environment trigger the error.
Test Excel in Safe Mode and with new workbooks
Use this to help determine whether an add-in or the Excel installation is involved.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Excel formats, making it easy to bring existing spreadsheets into a different workspace. It does not repair the Microsoft Excel installation or guarantee identical external-link behavior.

Frequently Asked Questions
Why do external links show #REF in Excel?
A referenced workbook, sheet, or cell may be unavailable or invalid, although behavior can also depend on the link type and Excel environment. Check Data > Workbook Links or Data > Edit Links and inspect the affected formula.
Does choosing Don't Update always keep the saved values?
No. Excel may use saved values, but the result can depend on the link type, workbook compatibility, and Excel version. Compare the behavior with the environment where the workbook previously displayed correctly.
How do I point an Excel link to a moved workbook?
Go to Data > Workbook Links or Data > Edit Links, select the link, and choose Change Source. Browse to the source workbook in its current location.
How can I check whether an add-in causes the error?
Close Excel, hold Ctrl while opening it, and confirm the Safe Mode prompt. Open the workbook and repeat the update choice; if the result changes, review File > Options > Add-ins.




