Forum Discussion
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...
- 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
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,
Same answer as SergeiBaklan. I would have to see where the error is occurring in the query. Are there multiple queries?