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
Bookmarks