Zipping a Protected Workbook

G

Guest

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.
 
R

Ron de Bruin

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)
 
T

Tom Ogilvy

Yes. The workbook is encrypted when you protect at workbook level. The
encryption apparently does not provide the compressable patterns of an
unencrypted workbook.
 
G

Guest

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 said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to bypass password when pasting FROM a protected workbook 3
Protected Workbook 1
HELP: Update a password protected workbook and save it as unprotec 2
Protected Workbook Open, Odd worksheet size 2
Using Worksheet_change module in protected workbook. 3
Run a code on a workbook? 2
not able to enable macro in password protected .xlsm workbook. 2
Programatically filter a protected shared workbook 4

Top