Pivot table lost connection after modifying query. The query loads into a different table instead.|Power Query|Excel Forum|My Online Training Hub

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

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

TIA!