February 19, 2021
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.
July 16, 2010
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.