How to unsynch a copy of a PowerPivot worksheet from the original?

[FleurDeList]

When I copy a worksheet (within the same workbook) with a PowerPivot table or chart, the field list is synched up to the original. That means any changes I make in the copy are reflected in the original pivot table or pivot chart. This is not what I want. I want to be able to make a copy of a worksheet and make changes in the PowerPivot field list that do not affect the original version. Is there a setting for this?

 

[NickyvV]

When I copy a worksheet with a PowerPivot Table in it (I copied the whole worksheet and also tried CTRL+A and paste in a new worksheet), I don't get the mentioned behaviour.
I also tried this with a regular Pivot Table but the two tables are not synced with me. Could you explain in more detail what it is you are doing exactly? And what version of PP are you running?

HTH

 

[FleurDeList]

I am right-clicking on the worksheet tab and using the copy function. When I copy and paste a table as you suggested, the table is not synched. When I copy and paste a pivot chart, the new chart is still synched with the original. I really need these to be unsynched.

Thanks for your reply and your tips. Please let me know if you know how to unsynch a copied pivot chart.

 

[ChrisEAM]

I am right-clicking on the worksheet tab and using the copy function. When I copy and paste a table as you suggested, the table is not synched. When I copy and paste a pivot chart, the new chart is still synched with the original. I really need these to be unsynched.

Thanks for your reply and your tips. Please let me know if you know how to unsynch a copied pivot chart.

Does anybody have a definitive answer to this question? This Power Pivot pivot table copy behavior always drives me crazy so I end up starting from scratch on the new tab which is very time consuming. Any help would be much appreciated. Thank you!