Excel VBA - long time of refresh of linked table to Power pivot

[VladimirV]

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 speed up the refresh?

Thanks a lot to everybody for advices,
Vladimir