Hi,

I have a pivot table that obtains data from an Access database on a
quarterly basis. As at Q2 the pivot table file size was 20MB after retrieving
100,000 records from the database.
As at Q3 the pivot table file size was 75MB after retrieving 140,000 records
from the same database. Nothing has changed regarding the number of columns
etc. Just a refresh for updated data.
For the previous year: 50MB file for 250,000 records. Same database.

Any reason for the dramatic increase in file size for Q3?
Is this somehow related to the pivot table cache or memory? If so, how do I
fix this. I cleared the cache via a VBA macro, but this did not change
anything.

BTW I use Excel 2003.
Thanks!!