Calculation Issues

How to Stop Excel from Recalculating Formulas When Saving

Tauseeq MagsiTauseeq Magsi Oct 9, 2026 872 views

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.

How to Stop Excel from Recalculating Formulas When Saving
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 you start

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.

Solution 1Recommended

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.

1
Close all active workbooks

Save and close every Excel workbook currently open on your computer to ensure a completely fresh application session.

2
Open the affected file

Open only the specific workbook where you want to maintain the manual calculation setting.

3
Change Calculation Options

Navigate to the 'Formulas' tab on the top ribbon, click on 'Calculation Options', and select 'Manual'.

4
Disable calculate on save

Go to 'File' > 'Options' > 'Formulas'. Under the Calculation options section, uncheck the box for 'Recalculate workbook before saving'.

5
Save the workbook

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.

Prevent Calculation Settings Inheritance
Application-Level Settings Saved: By opening this workbook first and applying these steps, you establish 'Manual' as the default calculation mode for your entire Excel session.
Manage Calculation Options in WPS Spreadsheet

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
  2. 2. Access Calculation Settings: Navigate to the 'Formulas' tab located in the top ribbon and click the 'Calculation Options' icon.
  3. 3. Set to Manual Mode: Select 'Manual' from the drop-down menu so formulas only update when you specifically choose to calculate them.
  4. 4. Adjust saving preferences: Click 'Menu' in the top left, go to 'Options' > 'Calculation', and uncheck 'Recalculate workbook before saving', then click 'OK'.
Seamlessly control manual and automatic formula calculations to improve file performance.Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Lightweight software that handles large datasets with complex formulas smoothly.
microsoft office alternative - wps office

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.