Macro performance with Excel addin
I've recently started using the Excel addin (Analysis) to refresh my data and then using a few VBA routines to do some detailed data crunching and updating of a dashboard. When I run these macros in normal Excel mode then it takes around 2 seconds per routine but when I run the macros under the Analysis addin then the same routine takes almost a minute each.
Any reason why or settings I need to adjust to speed this up? The performance to refresh the data is fine, it's really only the Macro performance once they are running under the addin.
thanks in advance for any input provided.
You Need to turn off Events before your code runs:
.Calculation = xlCalculationManual
.EnableEvents = False
.ScreenUpdating = False
Afterwards enable them.