How to Stop Auto Calculation in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on February 22, 2023

This tutorial demonstrates how to stop Excel from calculating automatically and the difference between automatic and manual formula calculation.


stop auto calculation excel 1


Stop Auto Calculation

By default, Excel recalculates every formula in a workbook whenever a cell is changed. This can slow down work, especially in complex files with a huge number of formulas. To speed up the process, you can stop auto-calculation of formulas by changing it to manual. This means that formulas won’t be calculated automatically on every change in a workbook. There are two ways to achieve this. The first one is, in the Ribbon, go to Formulas > Calculation Options > Manual.


formula auto calculation manual 1


Another way to switch to the manual calculation is to change Excel settings.

First, open Excel and select Options at the end of the menu.


formula auto calculation options


If you are already in an Excel workbook, in the Ribbon, select File > Options.

  1. Now, select Formulas and go to the Calculation options section. Here you can find the Workbook calculation settings.
  2. Select Manual.
  3. Then click OK.


formula auto calculation settings 1


Manual Calculation: Calculate Now

To calculate formulas when auto-calculation is stopped, use Calculate Now in the Calculation Options. Let’s first see how data looks before calculating manually. For example, there are numbers in Columns A and B and the sum of those numbers in Column C.


excel auto calculation 1


If you change numbers in Columns A and B while auto-calculation is set to manual, you’ll see that sum in Column C does not update – no calculation is done.


stop auto calculation 1


So, when you’re ready to calculate all formulas, go to the (1) Formulas tab and click (2) Calculate Now.


calculate now formulas 1


Now all the formulas are updated, and the correct sums are calculated in Column C.

AI Formula Generator

Try for Free

See all How-To Articles