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...

excel

Formulas and Functions

Macros and VBA

JKPieterse
Mar 20, 2024
lichtpixel Does it work to uncheck the "Enable background refresh" property of the query:

JKPieterse

Silver Contributor

Mar 20, 2024

lichtpixel Does it work to uncheck the "Enable background refresh" property of the query:

lichtpixel

Copper Contributor

Mar 21, 2024

Thanks a lot, I enabled "fast data load" and disabled "background refresh", now it works fine!

Forum Discussion

how to automatically update a pivot table referencing a pivot table referencing query table

Resources