Zipping Excel files

[Brian]

If I zip up an Excel file of 7,115,716 bytes, the resulting zip file is
1,206,499 bytes, a reduction of 83%.

If I do the same with an Excel file of 25,063,936 bytes, the zip file is
23,762,662, a reduction of only 5%.

Does anyone know why this is?

 

[Frank Kabel]

Hi
could be anything:
- embedded objects
- wrong used range in the first sheet
- number of filles cells/formulas

So very difficult to give you a specific answer without knowing more
about your two files

 

[Ron de Bruin]

Hi Brian

Maybe your other file have protected sheets.
If you zip a file with protected sheets it will not reduce the size much

 

[Brian]

Hi Ron,

No, there are no protected sheets.

Brian

 

[Gord Dibben]

Brian

Depends on what is contained in the file.

Text will compress quite a lot, graphics/objects not very much.

For info on file compression visit.......

http://www.howstuffworks.com/file-compression.htm

Gord Dibben Excel MVP