ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy worksheet with Pivot Table and break link to original workshe (https://www.excelbanter.com/excel-worksheet-functions/6670-copy-worksheet-pivot-table-break-link-original-workshe.html)

setter-lover

Copy worksheet with Pivot Table and break link to original workshe
 
I have a Pivot Table and Chart that I want to copy multiple times so I can
have multiple filters and charts in one workbook . When I make a copy of
either worksheet, rename the worksheet and then change the filter on the
Pivot Table, the filter changes the original filter on the original worksheet
(and vice versa). How can I copy a worksheet or chart with a pivot table so
that I can change the filter and leave the original worksheet's filter intact?

Thanks!


All times are GMT +1. The time now is 04:17 AM.

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