How to make Excel stop calculating automatically

Is your Excel file calculating and recalculating all the formulas automatically, causing your entire computer to freeze? That’s likely because your Excel application’s “Workbook Calculation” is set to “Automatic” instead of “Manual”.

  • Excel 2003: Tools > Options > Calculation > Calculation > Manual
  • Excel 2007: Office button > Excel options > Formulas > Workbook Calculation > Manual
  • Excel 2010: File > Options > Formulas > Workbook Calculation > Manual

If you want your file to recalculate before saving, make sure to check the “Recalculate workbook before saving” option.

This entry was posted in General tips. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>