What calculation style does and why you might change it

By default, Excel recalculates every formula in your spreadsheet the moment you change any number or formula. This is automatic calculation, and it works fine for most spreadsheets. But if you have a large file with hundreds of formulas, or if you are building a model where you want to test different numbers without watching the screen freeze while Excel recalculates, you can switch to manual calculation instead. Manual calculation means formulas only update when you tell them to.

Calculation style is not about how Excel does math — it is about when. The math itself stays the same. You are just choosing whether Excel recalculates in the background constantly, or waits for you to press a button.

Most people never need to change this. But if you work with financial models, large datasets, or spreadsheets that pull data from external sources, knowing how to switch between automatic and manual can save you time and frustration.

Key Takeaways

  • Automatic calculation (the default) updates all formulas whenever you change a cell, which can slow down large files.
  • Manual calculation updates formulas only when you press Ctrl+Shift+F9 (Windows) or Cmd+Shift+F9 (Mac), or click the Recalculate button.
  • You switch calculation style in the Formulas tab under Calculation Options, where you choose between Automatic, Automatic Except for Data Tables, or Manual.
  • If you forget to recalculate before saving, Excel will warn you and offer to recalculate when you open the file next time.
  • Automatic Except for Data Tables is useful when you have data tables that recalculate slowly but want everything else to update in real time.

How to switch to manual calculation in Excel

Open the file you want to change. At the top of the screen, click the Formulas tab. In the ribbon, find the group labeled Calculation — it is usually toward the right side. Click the button labeled Calculation Options. A dropdown menu appears with three choices: Automatic, Automatic Except for Data Tables, and Manual. Click Manual.

That is it. From now on, formulas in this file will only recalculate when you tell them to. The file remembers this choice even after you close and reopen it, so you only have to do this once per file.

If you want to go back to automatic, follow the same steps and click Automatic instead.

How to recalculate when you are in manual mode

When calculation is set to manual, you have two ways to recalculate. The fastest is the keyboard shortcut: press Ctrl+Shift+F9 on Windows, or Cmd+Shift+F9 on Mac. This recalculates every formula in every sheet of the file at once.

The second way is to go back to the Formulas tab, click Calculation Options, and select Recalculate Now. This does the same thing as the keyboard shortcut, just slower. Most people use the keyboard shortcut because they are testing numbers and want to recalculate many times in a row.

If you only want to recalculate the current sheet instead of the whole file, press Shift+F9 on Windows or Shift+Fn+F9 on Mac. This is useful if you have a workbook with multiple sheets and only one of them is slow.

When manual calculation actually saves you time

Manual calculation helps most when your file is large and complex. If you have a spreadsheet with 500 formulas and you are changing 20 different cells to test a scenario, Excel would normally recalculate after each change — that is 20 recalculations. In manual mode, you change all 20 cells, then press Ctrl+Shift+F9 once, and get one recalculation. The file stays responsive while you work.

It also helps when you are pulling data from an external source — a database, a web query, or another file. These connections can be slow to refresh. In manual mode, you control when the refresh happens instead of waiting for it to happen in the background.

Data tables are a specific case. A data table is a range of cells that tests multiple scenarios at once — for example, showing profit at different price points and sales volumes. Data tables recalculate slowly because they run the same formula many times with different inputs. If you choose Automatic Except for Data Tables, everything else in your file recalculates automatically, but data tables only recalculate when you press Ctrl+Shift+F9. This is a middle ground that works well for many people.

What happens if you forget to recalculate before saving

If you close a file in manual calculation mode without recalculating, Excel saves the file with old formula results. The next time you open it, Excel shows a yellow bar at the top asking whether you want to recalculate. Click Recalculate and the formulas update to match your latest changes.

This is a safety feature. You will not lose work or end up with wrong numbers in your file — Excel just makes sure you know the results on screen might be out of date. If you are working with someone else and send them a file in manual mode, they will see the same yellow bar when they open it.

Troubleshooting: formulas not updating

If you change a number in your spreadsheet and a formula does not update, the most common reason is that calculation is set to manual and you forgot to recalculate. Press Ctrl+Shift+F9 (Windows) or Cmd+Shift+F9 (Mac) and the formulas should update when ready.

A less common reason is that the cell with the formula is formatted as text instead of a number or formula. If recalculating does not fix it, click the cell, look at the formula bar at the top to make sure it starts with an equals sign, and press Enter. If the formula bar is empty or shows text, you may need to re-enter the formula.

Another possibility is that the formula itself has an error — for example, it refers to a cell that no longer exists, or it has a typo. Look for a small red triangle in the corner of the cell or an error code like #REF! or #NAME?. These mean the formula has a problem, not that calculation is off.

Frequently Asked Questions

Does manual calculation change the numbers in my formulas?

No. Manual calculation only changes when formulas update on screen, not how they calculate. The math is identical. When you recalculate, you get the same result as you would in automatic mode.

Can I set calculation to manual for just one sheet instead of the whole file?

No. Calculation style applies to the entire file. But you can recalculate just one sheet by pressing Shift+F9 instead of Ctrl+Shift+F9, which is useful if only one sheet is slow.

What is the difference between Automatic and Automatic Except for Data Tables?

Automatic updates everything, including data tables, whenever you change a cell. Automatic Except for Data Tables updates regular formulas automatically but only recalculates data tables when you press Ctrl+Shift+F9. Use the second option if data tables are slowing down your file but you want everything else to update in real time.

If I send my file to someone else, will they see the same calculation setting?

Yes. The calculation style is saved with the file. If you set it to manual, anyone who opens the file will see manual calculation. They can change it themselves if they want.

Will manual calculation affect how my file works if I share it with others?

It will not break anything, but it may confuse people who are not expecting it. If you share a file in manual mode, the formulas will show old results until someone recalculates. It is usually safer to switch back to automatic before sharing, unless you have a specific reason to keep it manual.