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?
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?