Forum Discussion

Anwesh Gangula's avatar
Anwesh Gangula
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's avatar
    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
Celia_Alves's avatar
Celia_Alves
MVP
Jun 20, 2020

Anwesh Gangula and @Anjupjose

I would also suggest going to the properties of the query and uncheck "Enable background refresh" if possible. Depending on the situation, this setting may appear grayed out. But if it isn't, make sure it does NOT have a check mark and git it a try.

 

To go to the properties, you can open the queries pane on the right-hand side in Excel, and then right-click and choose Properties at the bottom of the menu.

 

  • stevenwm94's avatar
    stevenwm94
    Copper Contributor
    May 12, 2021

    Celia_Alves 

    Would you know why when I do this I get a error? 

    [Expression.Error] The Column "Col;umn2" of the table wasn't found.

     

    I also tried creating a new Excel document and try with a fresh connection (no step added) just loaded the data and unchecked Enabled Background Refresh - Error. When I check it runs perfectly.

     

    Thanks, 

    • Celia_Alves's avatar
      Celia_Alves
      MVP
      May 26, 2021
      Same answer as SergeiBaklan. I would have to see where the error is occurring in the query. Are there multiple queries?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 12, 2021

      stevenwm94 

      Not sure how the expression error could depend on refresh for the new query. Perhaps you may share query code?

Resources