If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Zipping Excel files
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? |
#2
|
|||
|
|||
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 -- Regards Frank Kabel Frankfurt, Germany "Brian" schrieb im Newsbeitrag ... 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? |
#3
|
|||
|
|||
Hi Brian
Maybe your other file have protected sheets. If you zip a file with protected sheets it will not reduce the size much -- Regards Ron de Bruin http://www.rondebruin.nl "Brian" wrote in message ... 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? |
#4
|
|||
|
|||
Hi Ron,
No, there are no protected sheets. Brian "Ron de Bruin" wrote in message ... Hi Brian Maybe your other file have protected sheets. If you zip a file with protected sheets it will not reduce the size much -- Regards Ron de Bruin http://www.rondebruin.nl "Brian" wrote in message ... 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? |
#5
|
|||
|
|||
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 On Fri, 20 Aug 2004 17:44:22 +0100, "Brian" wrote: Hi Ron, No, there are no protected sheets. Brian "Ron de Bruin" wrote in message ... Hi Brian Maybe your other file have protected sheets. If you zip a file with protected sheets it will not reduce the size much -- Regards Ron de Bruin http://www.rondebruin.nl "Brian" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Unifying data from various Excel files | Barak Turovsky | Worksheet Functions | 1 | January 22nd, 2004 11:57 PM |
cant open MS Excel files | Rita | Worksheet Functions | 0 | December 19th, 2003 12:16 PM |
Problem Opening Excel files | Paul Bull | Setting up and Configuration | 2 | November 9th, 2003 10:29 AM |
Excel merge files that work like Word merge files | Rick | Worksheet Functions | 2 | October 30th, 2003 01:30 AM |