Fix Excel Formulas Not Updating Automatically Between Worksheets
Question details
The user needs to restore automatic calculation for linked cells and formulas that span across different 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 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.
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.
Save your work across all currently open Excel spreadsheets, then completely close the Microsoft Excel application so no instances are running in the background.
Launch Excel and open the specific workbook that is experiencing the cross-sheet formula issues. Do not open any other files yet.
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.

Migrate Data to a New Workbook to Fix File Corruption
If resetting the calculation settings does not resolve the updating failure, the workbook itself may contain hidden corruptions preventing the calculation engine from functioning properly.
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. Download and Install: Visit the official WPS Office website to download the free suite and follow the quick installation prompts.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and click 'Open' to import your existing Microsoft Excel files directly.
- 3. Enjoy Seamless Calculations: Edit your data and watch as linked cells and complex formulas update automatically without requiring manual refreshes.

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.




