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.
[ad#in-post-ad] Turn Off Calculations in VBABelow 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.