Cloned Pivot Table Reacts the Same Way As Original

**boba7523** · 05-26-2020, 04:11 PM

Hi Excel Gurus!

I have a question around Pivot Tables. When I clone an existing Pivot Table, any changes I made to the initial one is also reflected in the second one. Is there a way to disable this from happening? It just started happening suddenly... It wasn't like this before.

Thanks for the help in advance!

**maniacb** · 05-31-2020, 12:54 AM

I have found that duplicating a pivot ties the pivots together, such that filtering one filters the other. To get around this, One must create a new pivot from scratch. Just don't copy/ paste the original pivot. I hope this helps

**boba7523** · 06-01-2020, 01:45 AM

Thanks for your reply. There's no way to unlink the 2nd pivot?

**rorya** · 06-01-2020, 03:48 AM

What do you mean by any changes? Things like grouping fields will be reflected in any pivots that use the same cache, but filtering one pivot table should not affect another unless you are using a slicer that is linked to both.

Cloned Pivot Table Reacts the Same Way As Original

LinkBack

Thread Tools

Rate This Thread

Display

Cloned Pivot Table Reacts the Same Way As Original

Re: Cloned Pivot Table Reacts the Same Way As Original

Re: Cloned Pivot Table Reacts the Same Way As Original

Re: Cloned Pivot Table Reacts the Same Way As Original

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How do I restore original Pivot Table data?

Reset to original values in pivot table

Add data not in original range to pivot table

Programmatically Return a Pivot Table to its Original State

Pivot Table - how to keep original sorting from data set

Applying filter to original data from pivot table

Original Source of Pivot Table Data

[SOLVED] Keeping original data format into a Pivot Table

Bookmarks

Bookmarks

Posting Permissions