Disable Automatic Calculation of values in a formula in Excel 2010


By default, the Automatic calculation feature of the Workbook will be enabled in the Excel Application. When the Automatic calculation feature is enabled, the excel application will recalculate the workbook automatically each time a value affecting a formula changes. In this tutorial you will be guided on how to disable this Automatic Calculation feature. If you disable this feature in the Excel program, you should calculate the workbook manually by pressing the F9 key or by using the Calculate Now command.


To disable Automatic calculation, do the following

1) Click on the “File” tab and then click on the ‘Options’ tab.


Figure 1



2) In the “Excel Options” window thus opened, click on the ‘Formulas’ tab.


Figure 2



3) Under the ‘Formulas’ tab, in the ‘Calculation Options’ category, select the radio button that says “Manual”.


Figure 3



4) In case, if you want to disable Automatic calculation only for the Tables present in the Workbook, then select the Radio button that says “Automatic Except for data tables”.


Figure 4



5) If you want to enable the Automatic calculation, then select the Radio button that says “Automatic”.


Figure 5



6) Finally click on the ‘OK’ button in the Excel Options window.


So, this is how you can enable and disable automatic calculation feature in Microsoft Excel 2010 Application.



Read Other Applications