Forum Discussion
Solved
how to automatically update a pivot table referencing a pivot table referencing query table
I have an xlsx file with multiple sheets that should update everything on load (opening file) - but it doesn't. The workflow: 1. sheet A is static data, sheet B is static data written by a PHP libra...
In general pivots get refreshed before queries.
You need a macro that refreshes the query first (I believe you have to disable background refresh in the properties) and the pivot second.