Jun 27 2018
05:44 AM
- last edited on
Jul 25 2018
10:05 AM
by
TechCommunityAP
Jun 27 2018
05:44 AM
- last edited on
Jul 25 2018
10:05 AM
by
TechCommunityAP
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 the Pivot table.
I would like to know and customize the order of Refresh. I would like the Query to be refreshed first and then the pivot table. How to achieve this?
Note: I did not load the query to a sheet, I loaded the query directly into a pivot table
Jun 27 2018 10:42 PM
SolutionJun 28 2018 08:46 AM
Jun 28 2018 04:38 PM
Jun 20 2020 12:33 PM
Jun 20 2020 12:56 PM
@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.
May 12 2021 08:51 AM
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,
May 12 2021 01:53 PM
Not sure how the expression error could depend on refresh for the new query. Perhaps you may share query code?
May 25 2021 06:29 PM
Jun 27 2018 10:42 PM
Solution