file size after adding a pivot table

  • Thread starter Thread starter Joker
  • Start date Start date
J

Joker

Hi,

I would like to ask why my excel workbook gets bigger after I add a Pivot
table in it. It becomes like 4 MB from 200KB. After compressing this file
with RAR, it becomes 35KB.

In Access it repairs and corrects the size of the file but in Excel there is
no such tool (or there is which i dont know)

Thanks for help,

J.
 
You have probably opted to save the data with the file, which wil
obviously increase the size. If you do not want to do this then righ
click table .. Options ... uncheck "Save data with table layout"
 
Back
Top