Can you have 2 pivot tables with the same data source that are not linked to each other.

[TomCon]

I have a pivot table.



I then made a second pivot table (using Insert|Pivottable) based on the identical data range. I want them to be "completely independent" views of the same source data.



But, when i do certain things in the second pivot table, changes are made to the first pivot table. "Grouping" for example. I started grouping items in the second pivot table, and it affected the way the items were grouped in the first pivot table.



Is there any way to make them completely independent of each other so i can make changes in each completely independently of what is in the other pivot table?



Thanks!

 

[Misca]

You're going to need two pivot caches: https://trumpexcel.com/pivot-cache-excel/