Move/Copy Pivot Charts to New WB

[sjha]

I have 6 Pivot Charts in WB1 and would like to move all of them to WB2. How do I do it? I tried standard move/copy and it does it but the Pivot Charts becomes Static. How would I move/copy w/o effecting any dynamics of the Picot Charts. I have no problem moving/copying the Pivot Tables to WB2. I am trying to avoid recreating charts in WB2. Appreciate your help as always. Thanks!!

 

[Derek Brown]

Have you tried to move the worksheets as a 'group'.
You will need to move the data on which the pivot table is built as well as the pivot table itself.
Assuming that each is on a separate worksheet, select the data worksheet and while holding down the Ctrl key, select the worksheet with the pivot table and the one with the pivot chart.
Now right mouse-click one of the TABs and select the COPY option etc.
Assuming that I understood your question, it works for me.