I have created a pivot table (say Pivot-1) using source data from a sheet
that contains around 18000 records/ rows of data. I created several other
pivot tables using the first pivot table as the reference for the data to
save memory. My source data sheet has now grown to 20000 rows of data/
records. If I change the data range for the first pivot table (Pivot-1) to
use the new and increased range, will all other dependent pivot tables
automatically reflect the new data range too? I don't see this happening and
I have to go into each pivot table and set the new data range so now my
workbook is hogging memory. I'm using Excel in Office 2003.