Macro SAPLogon is very slow

[reyemsaibot]

Hi,

I use the Analysis Office API to connect with the SAPLogon macro and refresh my reports. Unfortunately the logon macro needs about 30 seconds to connect to my SAP system.

I think this is very slow, because when I want to automate my reports (about 1.000 reports), I have to close and open Excel again, because Excel needs to much RAM after a few reports.

Is there anyone you have the same problems? Is there maybe a better solution? I use Analysis Office 2.2 SP2.

regards

Tobias

[reyemsaibot]

Has anyone an idea?

[TammyPowlas]

Only *related* item was this https://launchpad.support.sap.com/#/notes/1899658/E but it is old.  Something here might give you an idea?

[TammyPowlas]

Hello Tobias - are you using Excel 2013 or Excel 2016?  Maybe it's me, I find Excel 2016 faster - just a sense.  I am not using the Macro logon, however

[reyemsaibot]

Hi Tammy

I use Excel 2013.