Copy worksheet with Pivot Table and break link to original workshe

S

setter-lover

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top