How to Stop Excel from Recalculating Formulas When Saving
Question details
The user needs to understand why Excel resets calculation settings upon reopening a workbook, causing formulas to recalculate on save despite the manual calculation mode being active.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Reopening and saving an Excel workbook containing formulas where manual calculation is preferred.
- Observed behavior
- Excel recalculates formulas when saving because it inherits the calculation settings from other open workbooks, overriding the intended manual mode.
Before modifying calculation settings, make sure to close all other currently open Excel workbooks to prevent your file from inheriting automatic calculation settings from them.
Prevent Calculation Settings Inheritance
Excel applies the calculation mode of the first opened workbook to all others in the same session. Closing other workbooks before configuring the affected file will permanently resolve the issue.
Excel calculation settings are application-wide, not workbook-specific. If you open a workbook set to 'Automatic' and then open your 'Manual' workbook, the second workbook automatically inherits the 'Automatic' setting for that session.
Save and close every Excel workbook currently open on your computer to ensure a completely fresh application session.
Open only the specific workbook where you want to maintain the manual calculation setting.
Navigate to the 'Formulas' tab on the top ribbon, click on 'Calculation Options', and select 'Manual'.
Go to 'File' > 'Options' > 'Formulas'. Under the Calculation options section, uncheck the box for 'Recalculate workbook before saving'.
Click 'OK' to apply the settings, then save the workbook. As long as it is the first file opened in future sessions, it will retain the manual calculation mode.

Easily Control Formula Calculations with WPS Spreadsheet
WPS Spreadsheet provides straightforward calculation settings, making it easy to switch between automatic and manual modes without dealing with frustrating workbook inheritance issues. It serves as an excellent, seamless alternative for all your complex data processing needs.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Access Calculation Settings: Navigate to the 'Formulas' tab located in the top ribbon and click the 'Calculation Options' icon.
- 3. Set to Manual Mode: Select 'Manual' from the drop-down menu so formulas only update when you specifically choose to calculate them.
- 4. Adjust saving preferences: Click 'Menu' in the top left, go to 'Options' > 'Calculation', and uncheck 'Recalculate workbook before saving', then click 'OK'.

Frequently Asked Questions
Why does Excel change my calculation to automatic by itself?
Excel operates on an application-level calculation setting. If you open a workbook saved with 'Automatic' calculation first, all subsequent workbooks opened in that same session will automatically inherit the 'Automatic' setting, even if they were previously saved as 'Manual'.
How do I force Excel to calculate manually in a specific workbook?
To force manual calculation, ensure no other files are open, and then open only that specific workbook first. Go to Formulas > Calculation Options, select Manual, and save the file. This establishes manual calculation as the primary setting for the current Excel session.
Where is the 'Recalculate before saving' option located?
You can find this setting by navigating to File > Options > Formulas. Under the 'Calculation options' section, look for the 'Recalculate workbook before saving' checkbox directly below the Manual option.




