| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zipping a Protected Workbook
I have just run across something weird that I can not figure out. When I take
any spreadsheet and protect the workbook with a password, save the file and close it It takes about twice as long to save it as it would if I had not protected the workbook. When I zip the file it only compresses about 10% where as the unprotected version compresses about 75%. I am using Excel 2000 (9.0.6926 SP3). I am using WinZip version 10??? Has anyone else run across this behavior. -- HTH... Jim Thomlinson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zipping a Protected Workbook
Hi Jim
This is a known problem with workbooks that are protected I see that WinZip 10 is not better (I think I not upgrade) -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... I have just run across something weird that I can not figure out. When I take any spreadsheet and protect the workbook with a password, save the file and close it It takes about twice as long to save it as it would if I had not protected the workbook. When I zip the file it only compresses about 10% where as the unprotected version compresses about 75%. I am using Excel 2000 (9.0.6926 SP3). I am using WinZip version 10??? Has anyone else run across this behavior. -- HTH... Jim Thomlinson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zipping a Protected Workbook
When did this start. I am sure that I used to be able to do this... Do you
have a link to a description of the problem... -- HTH... Jim Thomlinson "Ron de Bruin" wrote: Hi Jim This is a known problem with workbooks that are protected I see that WinZip 10 is not better (I think I not upgrade) -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... I have just run across something weird that I can not figure out. When I take any spreadsheet and protect the workbook with a password, save the file and close it It takes about twice as long to save it as it would if I had not protected the workbook. When I zip the file it only compresses about 10% where as the unprotected version compresses about 75%. I am using Excel 2000 (9.0.6926 SP3). I am using WinZip version 10??? Has anyone else run across this behavior. -- HTH... Jim Thomlinson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zipping a Protected Workbook
Hi Jim
When did this start Always the same this behavior -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... When did this start. I am sure that I used to be able to do this... Do you have a link to a description of the problem... -- HTH... Jim Thomlinson "Ron de Bruin" wrote: Hi Jim This is a known problem with workbooks that are protected I see that WinZip 10 is not better (I think I not upgrade) -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... I have just run across something weird that I can not figure out. When I take any spreadsheet and protect the workbook with a password, save the file and close it It takes about twice as long to save it as it would if I had not protected the workbook. When I zip the file it only compresses about 10% where as the unprotected version compresses about 75%. I am using Excel 2000 (9.0.6926 SP3). I am using WinZip version 10??? Has anyone else run across this behavior. -- HTH... Jim Thomlinson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Zipping a Protected Workbook
Yes. The workbook is encrypted when you protect at workbook level. The
encryption apparently does not provide the compressable patterns of an unencrypted workbook. -- Regards, Tom Ogilvy "Jim Thomlinson" wrote in message ... I have just run across something weird that I can not figure out. When I take any spreadsheet and protect the workbook with a password, save the file and close it It takes about twice as long to save it as it would if I had not protected the workbook. When I zip the file it only compresses about 10% where as the unprotected version compresses about 75%. I am using Excel 2000 (9.0.6926 SP3). I am using WinZip version 10??? Has anyone else run across this behavior. -- HTH... Jim Thomlinson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If .xlsx is a zip archive, why does zipping it reduce file size? | Excel Discussion (Misc queries) | |||
| How can I reduce the size of my Excel file without zipping it? | Excel Discussion (Misc queries) | |||
| Zipping a file | Excel Programming | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Zipping Excel files | Excel Programming | |||
![Jim Thomlinson[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
