Calculation Issues

How to Fix Excel Links Reverting to Old Values

Elise WilliamsElise Williams Nov 11, 2026 868 views

Question details

The user needs to resolve an issue where external workbook links display outdated or obsolete values instead of updating correctly.

How to Fix Excel Links Reverting to Old Values
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.
Before you start

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.

Solution 1Recommended

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.

1
Update values via Edit Links

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.

2
Enable automatic calculation

Go to the Formulas tab, click on Calculation Options in the ribbon, and select Automatic from the dropdown menu.

3
Refresh all data connections

Switch back to the Data tab and click Refresh All to ensure all queries and external data references pull the latest information.

Force Update Linked Values and Enable Automatic Calculation
Update Prompts: You can configure Excel to prompt you to update links upon opening by clicking 'Startup Prompt...' in the Edit Links dialog box.
Seamlessly Manage Data Links

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. 1. Open linked workbooks: Launch WPS Spreadsheet and open your destination file.
  2. 2. Access link settings: Navigate to the Data tab on the top ribbon and click on Edit Links.
  3. 3. Update source data: Select your source workbooks from the dialog box and click Update Values to instantly sync your data.
  4. 4. Adjust calculation mode: Go to the Formulas tab, click Options, and ensure 'Automatic Calculation' is checked.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and formulasIntuitive Edit Links interface for quick updates and source managementLightweight architecture ensures fast calculation of complex linked dataBuilt-in error checking to resolve circular references effortlessly
microsoft office alternative - wps office

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.