Hi All,

I have a MS SQL stored procedure returning data to excel. After retrieval I carry out some actions using a macro. When I run the query and then run the macro, the macro takes a long time. If I run the query save, close and reopen the workbook and run the macro first, then it executes fast. I am using O365 excel and SQL standard 2014 on windows 10. Query has about 35000 records and about 150 columns.

I have the usual calculation to manual and screen update set to false before running the macro.

Any idea where to look for the issue?

Thanks in advance.

Amal