I am told that as long as my Excel is in "compatability mode", the passwords
are very easily discoverable. How do I get rid of that "mode". Thanks.

I am assuming you are using Excel 2007...

Not sure whether password protection would be better but you can save the
spreadsheet in Excel 2007 format (.xlsx) by choosing SAVE AS option and then
choosing Exel (.xlsx) as the format.

"Rex1939" wrote:

> I am told that as long as my Excel is in "compatability mode", the passwords
> are very easily discoverable. How do I get rid of that "mode". Thanks.

Someone told you a falsehood.

Internal passwords are easily discoverable in any mode.

File-to-open passwords and VBAProject passwords are a little more difficult
to crack, but can be done.


Gord Dibben MS Excel MVP


On Mon, 4 Jan 2010 17:34:01 -0800, Rex1939
<(E-Mail Removed)> wrote:

>I am told that as long as my Excel is in "compatability mode", the passwords
>are very easily discoverable. How do I get rid of that "mode". Thanks.