Can a pivot table be redirected to an external source?
 

I have already built an extensive file using multiple pivot tables where the
source data is contained within the same workbook; however, due to file size
and several other factors, I now need to separate the source data into its
own file and have all the pivot tables pull from the external source. To
complicate matters, each pivot table has its own chart associated with it.
Is there a way to keep the pivot tables & charts I've already built and just
re-direct them to pull from the external source? From what I can tell so
far, it's not possible. I really don't want to have to redo all the
tables/charts! I've seemed to have exhausted my search so I'm turning to
this group to help! Thanks in advance!

Can a pivot table be redirected to an external source?
 

I was able to accomplish this by moving (right click on sheet tab,
copy/move) the worksheet containing the source data to another workbook. All
the PivotTables automatically adjusted to follow them.

--
Best Regards,

Luke M
"KarenK" wrote in message
...
I have already built an extensive file using multiple pivot tables where
the
source data is contained within the same workbook; however, due to file
size
and several other factors, I now need to separate the source data into its
own file and have all the pivot tables pull from the external source. To
complicate matters, each pivot table has its own chart associated with it.
Is there a way to keep the pivot tables & charts I've already built and
just
re-direct them to pull from the external source? From what I can tell so
far, it's not possible. I really don't want to have to redo all the
tables/charts! I've seemed to have exhausted my search so I'm turning to
this group to help! Thanks in advance!

Try this:

1. go to PIVOT TABLE AND PIVOT WIZARD 1 OF 3
2. Keep opened other workbook which has consolidated pivot table
3. go to RANGE and just the select the entire pivot table in other workbook

all the best