Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
661
Views
Topic starter
Hello,
Is it possible with a Workbook.RefreshAll command (macro) to refresh all queries and the pivot tables which are using the result of the queries ?
One query has to wait for the previous to be ended. This can take a while because the query makes a connection to an Oracle Database.
The pivot tables has to be refreshed after that the last query is finished.
Thanks.
Posted : 25/02/2021 7:34 am
Hi Marc,
The answer to this is in my response to your previous question. In order to avoid two refreshes you need to build your PivotTables from the Pivot Cache or Data Model, as opposed to a table in the worksheet. This is because the PivotTable will refresh before the query has time to update the source data table.
Mynda
Posted : 25/02/2021 8:17 pm
