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

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" <(E-Mail Removed)> wrote in message
news:0531E270-E611-4CDC-A95F-(E-Mail Removed)...
> 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