Zipping Excel files

B

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?
 
F

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
 
R

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
 
Top