How can I change the source data reference to another pivot table?

A

apss40

I'm using Excel 2003. I have a pivot table (1) referencing around 20000 rows
of data. I have created other pivot tables using the first pivot table as the
source data reference so they share the same pivot cache. When my source data
range changes (say to 25000 rows), how can I make all tables reflect the
change and use the same pivot cache?
 
D

Dave Peterson

apss40 said:
I'm using Excel 2003. I have a pivot table (1) referencing around 20000 rows
of data. I have created other pivot tables using the first pivot table as the
source data reference so they share the same pivot cache. When my source data
range changes (say to 25000 rows), how can I make all tables reflect the
change and use the same pivot cache?
 

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

Top