Forum Discussion

Iron Contributor

Jun 27, 2018

Solved

Wait until Query is Refreshed

I have a query in my excel which is directly loaded to a Pivot Table. In the connection properties of the Query, I have set the query to refresh on workbook open. And I have done the same thing to th...

Excel Desktop

Macros & VBA

Wyn Hopkins
Jun 28, 2018
Hi Anwesh,

Are you using Power Query ?

If you set the Pivot to refresh on open and not the query then the Pivot Table will trigger the query to refresh and then update the Pivot

Wyn Hopkins

MVP

Jun 28, 2018

Hi Anwesh,

Are you using Power Query ?

If you set the Pivot to refresh on open and not the query then the Pivot Table will trigger the query to refresh and then update the Pivot

Anwesh Gangula
Iron Contributor
Jun 28, 2018
Okay, I didn't know that. That's great.
Does it work even if I have multiple pivot tables from multiple queries?
- Wyn Hopkins
  MVP
  Jun 28, 2018
  It should do, just mark each Pivot as refresh on open
  - Anjupjose
    Copper Contributor
    Jun 20, 2020
    I have a same question, Refresh on open not working in Pivot table .The source data is another sheet in the same workbook and the same got updated by power query from external data source. Powerquery updates ,but not pivot .Any idea why it is not updating after enabling the refresh on open for that pivot table?