Nov 29 2009

Macro to Disable Cell Calculations on a Sheet

If you’ve ever had a sheet in your project that has a number of formulas with calculations, you’ve no doubt noticed the slowdown that occurs when saving your spreadsheet or editing a formula.  Excel has a property that can be adjusted within a macro that allows you to turn on and off the calculations on a spreadsheet.

Turn Off Calculations in VBA
Below is the simple line of VBA code to turn off calculations on the currently active sheet.

Sub DisableCalc()

ActiveSheet.EnableCalculation = False

End Sub

That’s it.  You can also specify which sheet you would like to disable calculations for by using Sheets(“SheetName”).EnableCalculation = False.  To re-enable calculations just change the False to True in a 2nd macro.

This can also be achieved using the tools menu in Excel .  Using this trick will speed up your work by not making you wait for calculations to update all the time, as well as decreasing save time.  Just don’t forget to turn it back on before you need to use the calculations.

More Excel Tips

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 


Comments are closed.

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks