Can a pivot table be redirected to an external source?

K

KarenK

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!
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Write back from pivot table 1
Write back from pivot table 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot table data source 1
DATE Calculations in pivot table 0
Excel file linked to external source 0
How do I refresh Pivot Table from an external source ? 3

Top