Forum

Pivot table lost co...
 
Notifications
Clear all

Pivot table lost connection after modifying query. The query loads into a different table instead.

2 Posts
2 Users
0 Reactions
185 Views
(@duongph2502)
Posts: 1
New Member
Topic starter
 

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?

Screenshots:

1. The query Report loaded into pivot table with all the formats, slicers,...

1.png

2. Here's the query

2.png

3. I delete some steps, close and load

3.png

4. Now it's loading into a new table, while the existing pivot tables lose connection to the query, all the slicers are unresponsive

4.png

TIA!

 
Posted : 15/07/2023 11:30 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Duong,
Never seen this problem unfortunately.

Can you go to Pivot table ribbon tab and check the pivot source?

 
Posted : 18/07/2023 11:51 pm
Share: