Tag Archive: Making Copies of Pivot Table/Charts within Same Workbook


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


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 »