Tag Archive: Editing Pivot Table Impacts Original/Source Table

Oct
03
2013

Making Changes to Copied Pivot Table/Charts without Affecting the Source

image.png

When working with complex excel reports you might want to make copies of pivot tables/charts with slight variations within a same workbook. When you make copies pivot table/charts (straightforward copy/paste) and edit the grouping/fields of the copied table you would notice the original/source table also changes inline with the copied table/chart. Some blogs suggest the …

Continue reading »