Excel Calculation Tip

Microsoft Excel
1

In trying to continue to see how to speed up Excel, there are some calculation options you can use. (This mostly requires VBA)
The easiest is to turn off autocalculation. You can then manually calculate using the menus. (You can create VBA buttons to turn on/off.)
There is another option, where you turn off autocalculation and then use VBA to only calculate certain sheets or ranges. This way you can load up your transactions and then only calculate a sheet if you need it.
The VBA code for that is simple: you can put this on the sheets: ```
ActiveSheet.EnableCalculation = False
’ ActiveSheet.EnableCalculation = True

then use ```
Sheets(1).Calculate

for specific sheets.

1 Like