See all How-To Articles

How to Stop Auto Calculation in Excel

In this tutorial, you will learn 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, we 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 OptionsManual.

 

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

In order to calculate formulas when the auto calculation is stopped, you need to use Calculate Now in the Calculation Options. Let’s first see how data looks before calculating manually. For example, we have 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 the 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.