How to Turn Off Calculations in Excel 2010

Written by amanda rumble | 13/05/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.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.