To turn off automatic calculation in Excel for Microsoft 365 on Windows, open the Formulas tab, select Calculation Options, and choose Manual. Excel will then wait for you to recalculate formulas, which can help with large or calculation-heavy workbooks. Save a copy first if you want a safe way back, and remember that formula results may be out of date until you recalculate.
What You’ll Need
- Excel for Microsoft 365 on Windows and a workbook with formulas.
- Permission to edit the workbook if it is protected or read-only.
- Optionally, a saved copy of the workbook. Switching calculation modes does not remove formulas, but a copy gives you a fallback if you later save unintended changes.
Step-by-Step
- Open the workbook. Start Excel and open the file where you want to manage formula updates. If you have several workbooks open, be aware that the calculation mode can affect other workbooks in the same Excel session. Save any important work before changing it.
- Open the Formulas tab. On the ribbon at the top of Excel, select Formulas. Find the Calculation group. If the ribbon is minimized, expand it or use the tab names to locate the calculation controls.
- Open Calculation Options. Select Calculation Options in the Calculation group. The menu offers calculation modes such as Automatic, Automatic Except for Data Tables, and Manual. The names and available choices may vary slightly by Excel version.
- Choose Manual. Select Manual to stop Excel from automatically recalculating formulas whenever a relevant cell changes. The formulas remain in the workbook; the change affects when Excel updates their displayed results, not whether the formulas exist.
- Check a formula result. Change a harmless input cell that a formula depends on, or use a test copy of the workbook. In Manual mode, dependent results may remain unchanged until you request a calculation. Do not use an important live result as your test if someone relies on it being current.
- Recalculate when you are ready. Press F9 to calculate formulas in open workbooks, or press Shift+F9 to calculate the active worksheet. You can also use Formulas > Calculate Now for the workbook or Calculate Sheet for the active sheet. On some keyboards, especially laptops, you may need to hold Fn while pressing F9.
- Save the workbook. Save after choosing Manual if you want the workbook to retain the setting when it is reopened. Excel’s calculation mode is shared across workbooks in the same running instance, and a workbook’s saved mode can influence the mode when it is opened. If you work with several files, verify the setting rather than assuming each open workbook behaves independently.
To return to normal automatic updates, go to Formulas > Calculation Options > Automatic. If you use Automatic Except for Data Tables, ordinary formulas recalculate automatically while what-if analysis data tables are excluded from that automatic recalculation.
Common Mistakes
- Forgetting to recalculate before sharing. Manual mode can leave displayed values behind the latest inputs. Before emailing, printing, or presenting a workbook, calculate it and check a few key totals. If necessary, use Ctrl+Alt+F9 to force a full recalculation of formulas.
- Assuming Manual applies to just one sheet. The calculation mode is not a per-worksheet switch. A change can affect other workbooks open in the same Excel instance, so be alert if you have multiple files open at once.
- Confusing calculation mode with formula editing. Choosing Manual does not convert formulas to values or freeze the workbook permanently. You can still edit formulas and inputs; the main difference is that Excel does not routinely update dependent calculations until you request it.
- Saving without checking the results. Saving a workbook with stale displayed values can confuse another person who opens or previews it. Recalculate first when current results matter, then save and, if appropriate, switch back to Automatic.
- Expecting every Excel feature to behave identically. Some operations or functions may calculate when entered or refreshed, and external data connections have their own refresh behavior. Manual calculation controls formula recalculation; it is not a universal pause button for every workbook process.
Tips
- Use Manual for a specific workload, not by default. It is most useful when a workbook is slow because many formulas recalculate after each edit. For a small everyday budget or list, Automatic is usually simpler and reduces the risk of reading an outdated result.
- Make a recalculation routine. For example, finish a batch of input changes, press F9, review important totals, and then save. If only one sheet needs updating, select it and use Shift+F9 or Formulas > Calculate Sheet.
- Know the difference between F9 and a full rebuild. F9 calculates formulas that Excel determines need updating. If results still look wrong, Ctrl+Alt+F9 forces all formulas to recalculate. Ctrl+Alt+Shift+F9 also rebuilds the calculation dependencies before recalculating, which can help with unusual dependency problems.
- Label a manual-mode workbook. If coworkers use the file, add a visible note on a start or status sheet explaining that calculation is manual and when to recalculate. This is especially helpful for shared models and recurring reports.
- Consider whether only data tables are the issue. If what-if analysis data tables are making a workbook slow but you still need ordinary formulas to update automatically, choose Automatic Except for Data Tables instead of Manual.
- Keep a copy before changing a shared process. If the workbook supports a report or operational decision, make a copy and confirm the calculation workflow with other users. A changed calculation setting can surprise people who expect results to refresh immediately.
Troubleshooting
The results still change after selecting Manual. Confirm the setting under Formulas > Calculation Options. If another workbook is open, it may share the calculation mode, or a workbook opened later may have affected the session setting. Close unrelated workbooks, reopen the file you need, and check the mode again. Also distinguish formula calculation from data refresh: queries, links, and other connected content may have separate refresh controls.
The numbers look old after switching to Manual. That is expected until you calculate. Press F9 or select Formulas > Calculate Now. If you want all formulas forced to update, use Ctrl+Alt+F9. Check that you are viewing the correct workbook and worksheet, then inspect key results before relying on them. If the file contains external links or data connections, recalculate formulas and refresh the connected data separately as needed.
You cannot find Calculation Options. Make sure you are using the desktop Excel app and that the Formulas tab is visible. A narrow window or simplified ribbon can hide controls; maximize the window or expand the ribbon. In Excel for the web, look on the Formulas tab for Calculation Options; if the control is unavailable in your current web experience or workbook, open the file in desktop Excel to change the setting.
Excel switches back to Automatic or Manual unexpectedly. Check the mode after opening the file, particularly if you open multiple workbooks or start a new Excel session. Workbook calculation settings can interact across files in one instance. Close the workbooks, open the file whose setting you want to use first, select the intended mode, and save. If the issue continues, test with a copy and check whether an add-in, macro, or organization-managed workbook process changes calculation settings.
The F9 shortcut does not work. On a laptop, the function row may control brightness or volume unless you hold Fn. You can avoid the keyboard shortcut by using the Calculation group on the Formulas tab. On Mac, use Formulas > Calculation Options > Manual; the ribbon labels are similar, but function-key behavior depends on macOS keyboard settings and may require Fn.
Frequently Asked Questions
Does turning off automatic calculation change or delete my formulas?
No. It changes when Excel recalculates formulas. The formulas remain in their cells, but displayed results can be stale until you calculate again.
How do I turn automatic calculation back on?
Select Formulas > Calculation Options > Automatic. Then save the workbook if you want that setting retained for future use.
Can I turn off calculation for only one worksheet?
No. Excel’s calculation mode is not a per-sheet setting. You can manually calculate an individual sheet with Shift+F9 or Formulas > Calculate Sheet, but the mode itself is broader.
Will Manual mode make every workbook faster?
Not necessarily. It can reduce repeated recalculation in a large formula-heavy file, but it also makes results easier to leave out of date. Try it on a copy and compare the workflow before using it routinely.
What is the difference between Manual and Automatic Except for Data Tables?
Manual delays routine formula recalculation until you request it. Automatic Except for Data Tables recalculates ordinary formulas automatically but skips automatic recalculation of what-if analysis data tables.
Does the setting work in Excel for Mac?
Yes. In Excel for Mac, use Formulas > Calculation Options and select Manual. Function-key shortcuts can differ depending on your Mac keyboard settings, so the ribbon is a reliable alternative.
Related
- How to Share Excel in Google Drive: A Clear Guide
- How to Share Excel in Microsoft 365
- How to Shade a Cell in Excel With Two Colors
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Paste Values Shortcut: Keys, Options, and FixesIn Excel for Microsoft 365 on Windows, copy the cells, select the destination, then press Ctrl+Alt+V, press V,…
- Excel Not Responding? Recover Files and Find Temp DataIf Excel is not responding, first give it a minute and avoid repeatedly clicking or ending the task;…
- Excel Scatter Plot Labels: Add Names to PointsTo label points in an Excel scatter plot with names, select the chart, choose Chart Design > Add…
- Create a Questionnaire Template in Word Step by StepTo create a questionnaire template in Microsoft Word, lay out your questions and response areas in a document,…
- Excel Data Analysis Regression: Run and Interpret ItTo run a linear regression in Excel for Microsoft 365 on Windows, arrange the outcome values in one…
- Excel Named Range Scope Greyed Out? How to Change ItIn Excel for Microsoft 365 on Windows, a named range’s scope is fixed when the name is created,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.