MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


Posted by Alejandro Callejo on November 20, 2001 3:35 PM

Hi all

I'm having exactly the same problem. Could anyone help with this problem?

Thanks
Rgrds

Posted by Mark W. on November 20, 2001 3:44 PM

1. Right click your PivotTable and choose Wizard...
from the popup menu.
2. Press [ < Back ] until you reach Step 1 of 4.
3. Click the "Another PivotTable" radio button
and press [ Next > ].
4. Choose the desired base PivotTable from the
list and press [ Finish ].

Posted by Alejandro Callejo on November 20, 2001 3:44 PM

I found the solution at MS web site, check
http://support.microsoft.com/support/kb/articles/Q110/3/43.asp

Looks like it works fine.

Thanks
Rgrds

Posted by David Schwartz on November 20, 2001 9:15 PM

Thanks to both of you. Yes it does work.
My 55(!!!!)MB file is now back down to 9MB.