I can't find the Pivot Table Wizard in 2007. How do I find where to make this
change in 2007?

"Ron Coderre" wrote:

Each new pivot table creates a hidden copy of the source data. That's how you
can keep working with the same pivot table data eve if the source data
changes.

You have the option to make pivot tables share the same cached source data
when you create the pivot table.

If you open the pivot table wizard and click the [back] button to Step 1 of
3...
Select the 4th option button (Another Pivot Table report...)

Then click the [Next] buttons, to verify the remaining settings.
The file size will decrease.
Do that for all but the one pivot table that will be the basis for the others.

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"1genxer" wrote:

I have a file with about 8,000 rows of data and about 30 columns. I have
about 26 pivot tables that are in one of the sheets. The file is over 13MB.
If I delete the pivots my file size drops to only 6MB.

My question is, A) how much space does a Pivot Table take in a file, is it
the full size of the data it refrences? B) Is there a way to reduce the
amount of file space of the Pivot Table?

Any help would be much appreciated as a 13 MB file is very unwieldy to
update and manipulate when opened, and the file just gets bigger every month.
Thanks!!!