Disable Formula Updates in Excel 2010

You can use formulas in Microsoft Excel 2010 to perform calculations based upon the values in your spreadsheet. The benefit to using cell numbers and letters over actual values is that the formulas that you have created will update their values if you edit a cell value. This is extremely helpful and can aid you when you have large spreadsheets with entries that are frequently updated. Unfortunately, if your spreadsheet is very large and contains a high number of formulas, then updating all of your formula values can be a pretty time-consuming and resource-intensive activity. Fortunately you can make Excel 2010 stop updating your formula totals whenever you make a change to a cell and instead execute all of your formula calculations manually.


Turn on Manual Calculations in Excel 2010


Note that this method will not stop Excel from executing formulas that consist of only numbers and mathematical operator symbols. Applying this change will simply get Excel to stop updating existing formulas when you make a change to a cell value that is included as part of the formula’s calculation. If, after applying the manual calculation setting, you create a new formula, that formula will still be executed. But if you change the value of a cell included in the formula after its’ initial execution, the original value will remain.

Open the Excel file for which you wish to disable calculations.

Click the Formulas tab at the top of the window.

click the formulas tab


Click the Calculation Options drop-down menu in the Calculation section of the ribbon, then click the Manual option.

disable formula updates in excel 2010


You can now choose when you want to update your formulas on the spreadsheet. This allows you to avoid constant formula updates that can drastically slow down editing time on large spreadsheets. You can click the Calculate Now button in the Calculation section of the ribbon when you are ready to update your formula values.

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.