Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Macro performance with Excel addin


Hi,

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.

Peter

Tags:
Former Member
Former Member replied

You Need to turn off Events before your code runs:

With Application                                

.Calculation = xlCalculationManual      

.EnableEvents = False      

.ScreenUpdating = False  

End With

Afterwards enable them.

Best regards,

Victor

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question