Calculation Issues

Fix Excel Formulas Not Updating Automatically Between Worksheets

Phi Hung VoPhi Hung Vo Nov 3, 2026 869 views

Question details

The user needs to restore automatic calculation for linked cells and formulas that span across different worksheets.

How to Fix Excel Formulas Not Updating Automatically Between Worksheets
Product
Microsoft Excel
Device & OS
not provided
Scenario
Working with complex workbooks where cells reference data on other worksheets, expecting values to refresh instantly when source data changes.
Observed behavior
Linked cells display outdated values and do not update automatically. Even after pressing F9, toggling Automatic calculation, or restarting Excel, the cells only update when manually double-clicked.
Before you start

Before modifying settings or moving data, verify if the issue happens in all your Excel files or just a specific workbook. This helps determine whether the problem is an application setting or a corrupted file.

Solution 1Recommended

Clear Inherited Calculation Settings by Resetting the Excel Session

Excel can secretly inherit 'Manual' calculation settings from the very first workbook opened during an active session. Completely closing all windows and reopening the affected file first will reset this behavior.

When you open multiple workbooks, Excel applies the calculation mode of the first opened file to all subsequent files. If a previously opened workbook was saved in Manual mode, your current workbook will stop updating automatically.

1
Close all active Excel windows

Save your work across all currently open Excel spreadsheets, then completely close the Microsoft Excel application so no instances are running in the background.

2
Open only the problematic workbook

Launch Excel and open the specific workbook that is experiencing the cross-sheet formula issues. Do not open any other files yet.

3
Verify Automatic Calculation

Navigate to the 'Formulas' tab on the top ribbon. Click on 'Calculation Options' and ensure that 'Automatic' is selected. Test your linked cells to see if they update.

Clear Inherited Calculation Settings by Resetting the Excel Session
Check Hidden Workbooks: Sometimes an add-in or a hidden personal macro workbook (PERSONAL.XLSB) opens first in the background and sets the calculation mode to Manual.
Free Microsoft Office alternative

Experience Flawless Formula Calculations with WPS Office

If Microsoft Excel continues to struggle with session inheritance bugs or file corruption, consider switching to WPS Office. It provides a lightweight, highly compatible alternative that handles complex cross-sheet calculations flawlessly and is completely free to use.

  1. 1. Download and Install: Visit the official WPS Office website to download the free suite and follow the quick installation prompts.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and click 'Open' to import your existing Microsoft Excel files directly.
  3. 3. Enjoy Seamless Calculations: Edit your data and watch as linked cells and complex formulas update automatically without requiring manual refreshes.
100% compatibility with Microsoft Excel (.xlsx, .xls, .csv) formatsReliable automatic formula engine that prevents manual calculation bugsLightweight application that opens quickly without system lagFamiliar spreadsheet interface ensuring a seamless migration process
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel suddenly change to manual calculation?

Excel applies the calculation setting (Automatic or Manual) of the very first workbook you open to the entire application session. If the first workbook was saved with manual calculation enabled, any subsequent workbook you open will also default to manual calculation, temporarily stopping formulas from updating.

What does pressing F9 do in Excel?

Pressing the F9 key forces Excel to manually recalculate all formulas in all open workbooks. This is typically used when the calculation setting is on 'Manual' to improve performance in heavy spreadsheets, allowing you to update values only when you are ready.

Can a circular reference cause my formulas to stop updating?

Yes. If your workbook contains a circular reference (where a formula refers back to its own cell directly or indirectly), Excel may halt automatic calculations to prevent an infinite loop. Check the bottom status bar in Excel; if it displays 'Circular References', you must resolve it to restore normal formula updating.

How do I know if my Excel file is actually corrupted?

Common signs of file corruption include formulas refusing to update even on Automatic mode, frequent crashing or freezing when opening the file, formatting changes saving incorrectly, or Excel displaying 'File Error' messages during launch.