Password Protection in Excel - how can you find?

  • Thread starter Thread starter Don
  • Start date Start date
D

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?
 
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?
 
Don said:
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?
 
the supervisor does not remember, she thought she put in the correct password.

tried combos of upper case /lower case to to luck
 
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
 
Back
Top