Excel Stop Auto Calculation: Switch to Manual Mode
To stop Excel recalculating formulas automatically, change the workbook calculation setting from Automatic to Manual. In desktop Excel, open the Formulas tab, choose Calculation Options, and select Manual; you can then recalculate when you choose.
Change Excel to manual calculation
- Open the workbook in the Excel desktop app.
- Select the Formulas tab.
- In the Calculation group, select Calculation Options.
- Choose Manual.
When Manual is selected, edits that affect formulas generally do not update their displayed results until a calculation is triggered. The workbook can still be edited and saved, but formula values may be out of date. If you want Excel to calculate formulas whenever you save, enable Recalculate workbook before saving in the calculation options, if that option is shown in your version.
The setting is usually shared across open workbooks in the same Excel session, rather than acting as an isolated switch for just the active sheet. A workbook opened after another workbook may therefore appear to inherit the current calculation mode. Check the setting when results behave unexpectedly.
How to recalculate formulas manually
Manual mode does not remove formulas or prevent you from updating their results. Use Excel’s recalculation commands when you are ready:
- F9: Recalculates formulas in all open workbooks that Excel considers to need calculation.
- Shift+F9: Recalculates the active worksheet.
- Ctrl+Alt+F9: Forces a full calculation of formulas in all open workbooks, including formulas Excel might not otherwise consider changed.
- Ctrl+Alt+Shift+F9: Rechecks formula dependencies and then performs a full calculation. This can help if Excel’s dependency tracking seems inconsistent.
Keyboard shortcuts can vary with keyboard layout, operating system, or function-key settings. On some laptops, you may need to hold an Fn key as well. The equivalent commands are available through Excel’s calculation controls or ribbon, though their exact placement may vary by version.
Why Excel recalculates automatically
Excel’s normal setting is Automatic. When you change a cell used by a formula, Excel updates dependent formulas so the results stay current. For a small workbook, this is usually convenient and helps avoid decisions based on stale values.
Large or complex workbooks can take noticeably longer to recalculate. Common causes include formulas copied across many rows, extensive references between worksheets, large data tables, and functions that recalculate frequently. Some functions, such as NOW() and RAND(), are volatile: they may recalculate whenever Excel recalculates, even when their apparent inputs have not changed. Manual mode can make editing smoother while you make many changes, but it also makes it easier to overlook outdated results.
When manual mode is useful—and when it is risky
Manual calculation can be useful when you are making a batch of edits to a slow workbook, entering a large set of data, or temporarily changing assumptions in a model. For example, if a workbook has thousands of formulas and each input edit causes a long pause, you can switch to Manual, make the related edits, then recalculate once to review the updated results.
It is less suitable when other people rely on the workbook’s displayed values being current, or when you frequently change inputs and may forget to recalculate. A cell showing a number does not necessarily mean that number reflects the latest inputs. Before sharing, printing, or using results, recalculate and check that the workbook is in the intended mode. Consider adding a clear note to a workbook used by others if it is deliberately left in Manual mode.
Automatic, Manual, and partial calculation
Excel’s calculation options may include Automatic, Automatic Except for Data Tables, and Manual. The middle option keeps ordinary formulas automatic but excludes what-if analysis data tables from automatic recalculation. It can be a useful compromise when those tables, rather than the rest of the workbook, are causing delays.
These options control when Excel updates formulas; they do not change the formulas themselves. Nor do they make a workbook permanently faster: the work still needs to be recalculated when current results are required. If a workbook feels slow even in Manual mode, editing, saving, opening, or other workbook operations may be the bottleneck rather than formula recalculation alone.
Common problems and fixes
- Formulas are not updating: Check Formulas > Calculation Options. If Manual is selected, press F9 or switch back to Automatic.
- Only some results update: Use Ctrl+Alt+F9 for a full calculation. If results still look wrong, Ctrl+Alt+Shift+F9 rebuilds dependencies before recalculating.
- Another workbook changes the behavior: Recheck calculation mode after opening other files. Excel’s calculation setting can affect multiple open workbooks in a session.
- Excel returns a formula instead of a value: This is not necessarily a calculation-mode issue. Check that the cell is not formatted as Text, that the formula begins correctly, and that Show Formulas is not enabled.
- Excel keeps calculating despite Manual mode: Some actions or features may trigger calculation, and a full recalculation shortcut explicitly forces it. Manual mode reduces routine automatic recalculation; it is not a guarantee that no calculation can ever occur.
If the ribbon option is unavailable or the interface differs, check Excel’s application settings for the calculation options. Excel for the web and mobile apps may offer different controls from desktop Excel; if you cannot find the setting, use the desktop app or consult the help for the version you are using.
Frequently Asked Questions
How do I turn off automatic calculation in Excel?
Go to Formulas > Calculation Options > Manual in desktop Excel. Use F9 when you want to recalculate.
How do I turn automatic calculation back on?
Select Formulas > Calculation Options > Automatic. Excel will then update dependent formulas as inputs change.
Does Manual calculation apply to one worksheet?
It is not generally a per-worksheet switch. Calculation mode can affect open workbooks, so check the option when working with multiple files.
Will Excel recalculate when I save in Manual mode?
Not necessarily. Look for Recalculate workbook before saving in the calculation options if you want a calculation before saving. Otherwise, recalculate explicitly and verify the results.
Why are formulas still recalculating in Manual mode?
Manual mode stops routine automatic recalculation, but commands such as Ctrl+Alt+F9 force it. Certain workbook actions may also initiate calculation.
Can I stop only Excel data tables from recalculating?
If available, choose Automatic Except for Data Tables. This keeps other formulas automatic while excluding what-if analysis data tables.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.