Fix Excel Workbook Links That Do Not Update
Question details
The user needs Excel to update external links from another workbook.

- 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.
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.
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.
In Excel, select File > New > Blank workbook.
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.
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.
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.

Check Link Sources, Permissions, and Security Settings
Use these checks when Excel cannot identify or update the linked source.
Install Available Microsoft Excel Updates
Update Excel before retesting in case the issue has been addressed in a newer release.
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.

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.




