Size of file with pivot table

[Nadine]

I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot
table would cause the file to be so large when the 8MB file already had pivot
table sin it?
When it was 8MB, it had 6 pivot tables.
Now it's 20MB and it has 7 pitvot tables.
Why is this one table so much larger?

 

[Luke M]

Were the 6 PivotTable independent, or did they all use the same cache?

If you build PivotTables that use another PivotTable as reference (for when
you're reference the same raw data, just taking a different look at it),
they don't have to build a seperate PivotCache, and this significantly
reduces file size.

So, if the previous 6 were based on a single set of data, but the 7th is
independent and/or based on a larger set of data, this could account for
file bloat.

 

[Nadine]

That's a great observation. I will look into this. Your response is greatly
appreciated.