Password Protection in Excel - how can you find?

[Don]

I have created an Excel file for a group of people with one sheet protected.
It appears that one of the supervisors unlocked the sheet and protected it
with another password and now I can not unlock to fix a formula issue. I
will have to redo this file.

Is there a way to find out what the password for a sheet is if it is locked
and you forgot the password or it has changed?

 

[Niek Otten]

Look here:

http://www.mcgimpsey.com/excel/removepwords.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have created an Excel file for a group of people with one sheet protected.
| It appears that one of the supervisors unlocked the sheet and protected it
| with another password and now I can not unlock to fix a formula issue. I
| will have to redo this file.
|
| Is there a way to find out what the password for a sheet is if it is locked
| and you forgot the password or it has changed?

 

[JoeSpareBedroom]

I have created an Excel file for a group of people with one sheet
protected.
It appears that one of the supervisors unlocked the sheet and protected it
with another password and now I can not unlock to fix a formula issue. I
will have to redo this file.

Is there a way to find out what the password for a sheet is if it is
locked
and you forgot the password or it has changed?

Why not ask the supervisor?

 

[Don]

the supervisor does not remember, she thought she put in the correct password.

tried combos of upper case /lower case to to luck

 

[Don]

Very cool, it worked great. Scary that this worked so well and so simple to
crack protection. I will NOT tell my co-workers so they will continue to
watch protecting sheets properly.

thanks, have a great day