Hello friends
I use this code to refresh
Power query and table based on power query and pivot table posed on the table
but not work
On Error Resume Next
Application.DisplayAlerts = False
ActiveWorkbook.Connections("Query - PROJECT").Refresh
Sheets("Summary Data").ListObjects("PROJECT_1").QueryTable.Refresh BackgroundQuery:=False
ThisWorkbook.RefreshAll
I need to update
(1) Power query
(2) Table (based on power query)
(3) Pivot Table (based on Table)
By code
I use this code to refresh
Power query and table based on power query and pivot table posed on the table
but not work
On Error Resume Next
Application.DisplayAlerts = False
ActiveWorkbook.Connections("Query - PROJECT").Refresh
Sheets("Summary Data").ListObjects("PROJECT_1").QueryTable.Refresh BackgroundQuery:=False
ThisWorkbook.RefreshAll
I need to update
(1) Power query
(2) Table (based on power query)
(3) Pivot Table (based on Table)
By code