Zipping a Protected Workbook

[Jim Thomlinson]

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

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jim Thomlinson" <[email protected]> wrote in message news:[email protected]...
>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

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

--
Regards,
Tom Ogilvy

"Jim Thomlinson" <[email protected]> wrote in message
news:[email protected]...
> 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

[Jim Thomlinson]

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" <[email protected]> wrote in message news:[email protected]...
> >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
>
>
>

[Ron de Bruin]

Hi Jim

> When did this start
Always the same this behavior




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jim Thomlinson" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
>> >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
>>
>>
>>