Formula Errors

Fix Excel External Links That Change to #REF

Ayan MasoodAyan Masood Nov 22, 2026 868 views

Question details

Identify why Excel external links display #REF after a link-update choice and determine how to restore valid references.

Fix Excel External Links That Change to #REF
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.
Before you start

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.

Solution 1Recommended

Check the link source and repair invalid references

Use this when the source file has moved, is unavailable, or contains changed references.

1
Inspect the links

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.

2
Locate the source

Open the source workbook from its current location and verify that the referenced sheet and cells still exist.

3
Change the source if needed

In Workbook Links or Edit Links, select the affected link and choose Change Source. Browse to the correct source file and confirm the selection.

4
Review affected formulas

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.

Check the link source and repair invalid references
Cached values may vary: Choosing Don't Update may retain saved values, but it does not guarantee that every external link will display correctly. Avoid breaking links unless you intend to replace formulas with their current values.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesReview spreadsheet formulas in a familiar interfaceUse a free, lightweight office suiteMove existing Office documents into a familiar workspace
microsoft office alternative - wps office

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.