W
Welsh Wizard
I have a large and complex Excel workbook, with perhaps 20 large sheets. All
redundant data, cells etc have been removed.
When saves as .xlsx it occupies almost 3MB of disk space. However, if I
compress it to a .zip or a .rar, using any standard tool, it reduces to about
25% of that, under 700MB.
As .xlsx is already a zip archive, why can it be so massively further
reduced in size? Zipping a zip usually has no effect or even increases the
size. Why aren’t Microsoft using a more efficient compression technique?
File size can be a problem when trying to email, for example, multiple
versions of the file.
redundant data, cells etc have been removed.
When saves as .xlsx it occupies almost 3MB of disk space. However, if I
compress it to a .zip or a .rar, using any standard tool, it reduces to about
25% of that, under 700MB.
As .xlsx is already a zip archive, why can it be so massively further
reduced in size? Zipping a zip usually has no effect or even increases the
size. Why aren’t Microsoft using a more efficient compression technique?
File size can be a problem when trying to email, for example, multiple
versions of the file.