LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default If .xlsx is a zip archive, why does zipping it reduce file size?

Oops.

The programs ask you if you want the smallest size and slowest speed or larger
size and faster speed.



Dave Peterson wrote:

First, I have no idea.

Second, I know that there are zip programs that ask you want you want--smallest
file size and fastest speed or larger size and slower speed (and options between
these two).

Maybe it's just a choice that MS made to keep the time to create/update the file
reasonable.

Welsh Wizard wrote:

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 arent Microsoft using a more efficient compression technique?
File size can be a problem when trying to email, for example, multiple
versions of the file.


--

Dave Peterson


--

Dave Peterson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reduce File size Jeremy Ng Excel Discussion (Misc queries) 4 May 12th 09 11:50 PM
how to set sheet size to reduce file size LJ Excel Discussion (Misc queries) 1 November 26th 06 02:35 AM
reduce file size Cruz Excel Discussion (Misc queries) 2 October 6th 06 11:14 PM
How can I reduce the size of my Excel file without zipping it? Sizerd Excel Discussion (Misc queries) 1 February 13th 06 11:58 AM
Reduce size file tempêtje Excel Discussion (Misc queries) 2 March 29th 05 12:19 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"