I have limited practice with this, but I think if you copy the sheet with
the pivot table and chart to a new workbook, the links travel with the
copied pivot table, not the original. You can then move the sheet into the
original workbook.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MRIreland" wrote in message
...
In Excel 2007 can you change the source data of a pivot chart I have
multiple
charts and tables which I want to copy but the copied charts still refer
to
the original pivot table