Data Import & Export

Fix Excel Workbook Links That Do Not Update

Steve KSteve K Nov 14, 2026 868 views

Question details

The user needs Excel to update external links from another workbook.

Fix Excel Workbook Links That Do Not Update
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook contains external references to a source workbook and is expected to update automatically.
Observed behavior
Excel shows an Unknown link status and warns that values from the source workbook were not updated, even though the source and automatic updates are available.
Before you start

Confirm that you can open the source workbook and that it contains the referenced data. Locate both workbooks and note the source file's current path before checking the links.

Solution 1Recommended

Recreate the Workbook and Relink Its Sources

Use this approach if the workbook or its template may be damaged and other link checks do not resolve the issue.

1
Create a new workbook

In Excel, select File > New > Blank workbook.

2
Copy the affected content

Copy the affected sheets or cells from the original workbook into the new workbook. Check that formulas, formatting, and any required named ranges are present.

3
Recreate external links

Use Data > Workbook Links or Data > Edit Links, depending on your Excel version, to change the source if needed. Alternatively, edit the affected formulas to reference the correct source workbook.

4
Test the links

Save and reopen the new workbook, then use Data > Workbook Links or Edit Links to update the values. Check that the results match the source workbook.

Recreate the Workbook and Relink Its Sources
Check workbook features: Moving content to a new workbook may require you to recreate features such as named ranges, connections, or macros. Test the new workbook before relying on it.
Free Microsoft Office alternative

Work with Excel Files in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet and move between office suites more easily; it does not repair Microsoft Excel's link settings.

Open and edit Microsoft Excel XLSX filesReview formulas and workbook data in WPS SpreadsheetUse a familiar interface for an easier transition from ExcelGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

What does Unknown status mean for an Excel workbook link?

It means Excel has not established a definitive status for the link. Open Data > Workbook Links or Data > Edit Links to inspect the source and try updating it.

How do I change a link to a moved source workbook?

Select Data > Workbook Links or Data > Edit Links, choose the affected link, and select Change Source. Browse to the source workbook's current location and test the update.

Why does Excel warn that linked values were not updated?

Possible causes include an incorrect source path, insufficient access, security settings, circular references, or a problem with the destination workbook. Check the source and update prompt first, then test a newly created workbook if needed.

How can I check for circular references?

In Excel, select Formulas > Error Checking > Circular References, if available, and inspect any listed cells. Also review formulas that link the two workbooks to see whether they refer back to each other.