How to Turn Off Calculations in Excel 2010

By Amanda Rumble

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 re-calculate the cell values.

Step 1

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

Step 2

Click "Calculation Options" on the far right side.

Step 3

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.