pi
Board Regular
- Joined
- Apr 11, 2006
- Messages
- 207
Hi!
Using Excel 2007. I work with XLSB to optimize file sizes.
I have a huge data table (file size 16 MB). I put it into a file with some analysis (some pivot tables without saving data, some formula driven tables). File size went up by less than 1 MB. Great.
Then I did some formula changes, added a sheet with only 12 cells used (!). File size went to 34 MB. I closed the file, reopened, saved again, down to 23 MB. But there it is. Still some 6 MB too much.
What's wrong? Any way to force Excel to save as little as possible?
pi
Using Excel 2007. I work with XLSB to optimize file sizes.
I have a huge data table (file size 16 MB). I put it into a file with some analysis (some pivot tables without saving data, some formula driven tables). File size went up by less than 1 MB. Great.
Then I did some formula changes, added a sheet with only 12 cells used (!). File size went to 34 MB. I closed the file, reopened, saved again, down to 23 MB. But there it is. Still some 6 MB too much.
What's wrong? Any way to force Excel to save as little as possible?
pi