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 Calculation Options drop-down menu in the Calculation section of the ribbon, then click the Manual option.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.