Copying pivot tables/ charts

[ansar]

I have created some pivot tables/charts on one worksheet for the year 2009, and I'm doing some similar work on data for different years:
Cutting and pasting of regular charts/ tables seems easy between worksheets: (updating Source Data etc seems easy enough with these charts).
I can't see a way to changing the source data for the pivot tables/ charts which I would like to copy over......
Or is there a way to do this automatically when copying and pasting?

[Andy Pope]

Select the PT and then use the Pivot Wizard, step back to the Source data part and change it.