Excel Copying Over Charts and Pivot Tables Help

[mfriend1]

Hi all,

I'm trying to figure out if there's a way to copy charts and pivot tables from one workbook to another while keeping the sources for the pivot tables and charts stay as is. What I mean by this is if the source of one of my pivot tables is a data table(the source in pivot table would say "Data!Table1") and I have the same data table in a new workbook I want the source to stay as "Data!Table1" when I copy that pivot table to the new workbook. Is there anyway to do accomplish this? Thanks

[Phersotty]

Pivot tables and charts are linked dynamically. If you change the view in one it could change the view in the other. It might be easier to keep the source data in a separate workbook and then use it as an external source for new pivot charts and tables in a separate workbook. This would allow different views to be saved as separate files.