How to Fix Excel Links Reverting to Old Values
Question details
The user needs to resolve an issue where external workbook links display outdated or obsolete values instead of updating correctly.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Updating and calculating external references between multiple connected workbooks.
- Observed behavior
- Linked cells show old values instead of the latest data from the source workbook due to calculation settings, broken links, or formula errors.
Ensure that the source workbook is accessible, has not been renamed or moved to a different folder, and is saved with the most recent data.
Force Update Linked Values and Enable Automatic Calculation
Manually refresh the external links and ensure Excel is configured to calculate formulas automatically so values do not remain stagnant.
By default, Excel might pause automatic calculations for large files to save resources, or a specific link might fail to refresh upon opening. Forcing an update and toggling the calculation settings generally resolves the issue.
Open the destination workbook. Navigate to the Data tab, click on Edit Links, select the source file from the list, and click the Update Values button.
Go to the Formulas tab, click on Calculation Options in the ribbon, and select Automatic from the dropdown menu.
Switch back to the Data tab and click Refresh All to ensure all queries and external data references pull the latest information.

Fix Formula Limitations and Circular References
Identify and resolve circular references or formula dependencies that block Excel from calculating linked data properly.
Rebuild Links from Clean Copies
Save the corrupted files as new workbooks to eliminate underlying file corruption bugs preventing updates.
Manage External Links Easily with WPS Spreadsheet
WPS Office Spreadsheet provides highly compatible and intuitive tools to manage external workbook links, seamlessly update values, and efficiently calculate complex datasets without lagging.
- 1. Open linked workbooks: Launch WPS Spreadsheet and open your destination file.
- 2. Access link settings: Navigate to the Data tab on the top ribbon and click on Edit Links.
- 3. Update source data: Select your source workbooks from the dialog box and click Update Values to instantly sync your data.
- 4. Adjust calculation mode: Go to the Formulas tab, click Options, and ensure 'Automatic Calculation' is checked.

Frequently Asked Questions
Why does the INDIRECT function show old values or errors?
The INDIRECT function in Excel requires the referenced external workbook to be actively open in the background. If the source file is closed, the formula cannot fetch new data and will either display the last calculated value or a #REF! error.
How do I find all external links hidden in my workbook?
You can find hidden links by pressing Ctrl + F to open the Find dialog, searching for '.xl' or '[', and looking in 'Formulas'. Additionally, check Data Validation rules, Conditional Formatting, and the Name Manager (Formulas > Name Manager) for hidden external references.
What does the 'Automatic Calculation' setting do?
Automatic Calculation tells the spreadsheet software to instantly recalculate any dependent formulas the moment a referenced cell or linked external data changes. If set to Manual, you must press F9 or click 'Calculate Now' to refresh the values.




