Dear All,
I have a problem with refreshing linked table (from Excel sheet where I have about 150.000 rows and 11 columns of data) to Power pivot model. It takes a quite long time.
So, I am using Office 365 ProPlus, version 1804 (Build 9226.2156). In my VBA code I have the following expression:
ThisWorkbook.Connections("linked_table_Name").Refresh
And this lasts about 4 minutes... What is wrong? How can I to speed up the refresh?
Thanks a lot to everybody for advices,
Vladimir
I have a problem with refreshing linked table (from Excel sheet where I have about 150.000 rows and 11 columns of data) to Power pivot model. It takes a quite long time.
So, I am using Office 365 ProPlus, version 1804 (Build 9226.2156). In my VBA code I have the following expression:
ThisWorkbook.Connections("linked_table_Name").Refresh
And this lasts about 4 minutes... What is wrong? How can I to speed up the refresh?
Thanks a lot to everybody for advices,
Vladimir