How to disassociate Pivot from Sheets

[findlay70]

Hello,
How do I disassociate my Pivot from each sheet I'm working with? I have charts in each sheet and each time I change the Pivot fields to crate a new chart, the charts on the other sheets change too.
I need to create independent sheets - please advise how I can do this...
Thanks
Andy

[matt.nicolai]

Have you tried copy/pasting the charts as an image or values?

[findlay70]

Thanks Matt. Yep, This is the solution I have used...
However, I'm testing 15+ charts with my team and dont want to have to keep re-creating them. I want to save the chart and then be able to come back to it. I know a solution also is to save each chart within an own file, but that is cumbersome.
I would have thought that the sheets would have acted independently, but they dont. I was hoping there was a way to "disconnect" the sheets so I could use a pivot for each.
Any other ideas would be appreciated..!
Thanks
Andy

[shashikiran.alloli]

Did u find the solution to this ?? If So pls let me know, even I'm facing the same problem.

[shashikiran.alloli]

Pls help me disassociate pivot table from sheets.

[VKS]

As Matt said Copy the pivot table and use paste special Values this will convert pivot table to a data set. Please note when you do this you will loose the pivot table and wont be able to reuse it as pivot so I would suggest you keep a copy of Pivot table in some other sheet in case you want to do some more reports using same pivot table.
Best Regards/Vineet

[FDibbins]

have you considered creating a new PT for the new chart?