July 15, 2023
I have this query loaded into a pivot table. I need to update the query, but after deleting a few applied steps and hit Close and Load (Close and Load to grayed out), it loads into a new table instead of refreshing the existing pivot table. I spent lots of time formatting the pivot table, adding slicers and stuff, I can't do it all over again. Could anyone please help?
1. The query Report loaded into pivot table with all the formats, slicers,...
2. Here's the query
3. I delete some steps, close and load
4. Now it's loading into a new table, while the existing pivot tables lose connection to the query, all the slicers are unresponsive