How to Turn Off Calculations in Excel 2010

Updated March 23, 2017

Microsoft Excel is a spreadsheet application included in the Microsoft Office Suite. Excel automatically recalculates cell values whenever a worksheet is modified. This can be a hindrance, especially if you need to make many updates to a large spreadsheet which takes a long time to recalculate. In this case, it may be beneficial to turn off calculations while you update the spreadsheet. When you are finished updating the values, turn calculations back on to recalculate the cell values.

Open Microsoft Excel and click "Formulas" in the Ribbon at the top of the Excel window.

Click "Calculation Options" on the far right side.

Select "Manual" to disable auto-calculation. If you want Excel to recalculate your spreadsheet while auto-calculation is disabled, you will need to click "Calculate Now," also located under "Calculation Options." When you are ready, you can re-enable auto-calculation.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Amanda Rumble has been writing for online publications since 2000, primarily in the fields of computing and technology. She holds a bachelor's degree from the University of Buffalo in information technology. Rumble also focuses on writing articles involving popular video games and Internet culture.