ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2007 - 2003 File Size (https://www.excelbanter.com/excel-discussion-misc-queries/190729-2007-2003-file-size.html)

jckieren

2007 - 2003 File Size
 
I have a workbook with two pivots and created from 59,000 rows of data. When
I save it in the 2007 xlsx format its 16M, but when I save in in the 2003 xls
format it grows to 108M. Can anyone tell me why the 2003 file is so much
larger?

John

Harald Staff

2007 - 2003 File Size
 
Hi John

The 2007 fileformat is just a zipped folder -rename it from .xlsx to .zip
and see what happens. So it isn't the 2003 file that is larger, it is the
2007 file that is smaller. Compression ratio depends on the content.

Best wishes Harald

"jckieren" skrev i melding
...
I have a workbook with two pivots and created from 59,000 rows of data.
When
I save it in the 2007 xlsx format its 16M, but when I save in in the 2003
xls
format it grows to 108M. Can anyone tell me why the 2003 file is so much
larger?

John





All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com