ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table copy and paste (https://www.excelbanter.com/excel-worksheet-functions/14563-pivot-table-copy-paste.html)

yllee70

Pivot table copy and paste
 
Hi,

Still struggling with the pivot tables. I copied and pasted a pivot table a
few rows below my original table. I have now pasted 4 pivot tables - 1
original and 4 copies. When I changed the format/group of 1 of the copied
tables, all the other 5 tables changed as well according to the new changed
format/group. How do I keep the 4 tables from changing each time I change one
of the pivot tables. Basically I want to play around with the formats/groups
and show 5 different formats/groups in 5 different tables.


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com