Keeping Files with Multiple Pivot Tables Small
Posted by David Schwartz on November 20, 2001 7:57 AM
I have built a set of pivot tables working off a single set of data. To keep the file small, I have indicated, as I built the pivot tables, that I wanted to "base it on an existing pivot table". (Excel dialogue box)
Now I want to go back and modify the data range on each of these tables. When I do this, I don't get the dialogue about "bas(ing) it on an existing pivot table". Even though the actual data in each one of the pivot tables is still exactly the same as all of the other tables, Excel doesn't seem to recognize that it is still using one data source. I can't seem to get to that dialogue box that allows me to indicate it.
As a result, my file size has exploded.
Is there a way when I modify the range to "let Excel know" that the multiple pivot tables are still based on a single set of data?