Password Protect Excel Spreadsheet?

[MikeJ]

Is there a way to password protect an Excel file so it can not be opened
without a password? If so, how secure is this?

Thanks!

 

[Dave Peterson]

When you do a file|saveAs, you can click on Tools|General Options (in xl2002)
where you can provide a password to open the file.

But there are commercial products that can crack this.

 

[jee22]

Hi Mike

Yes there is, FILE>SAVE AS then TOOLS>GENERAL OPTIONS
and enter your password.

Be warned pass words are case sensitive (A and a) also if you forget the
password you will not be able to open the file again. Although there may be
some options to recover from this else where. I am sure I have read
something but I cannot think where.

Best

J

 

[John McGimpsey]

Picky:

Length is only more secure if the password is not a dictionary word,
e.g., "g%#8&" is somewhat more secure than "password" (though both are
trivial).