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.