Password Protection in Excel - how can you find?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 19 May 2008 16:32 GMT

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?

Reply to this Message

Niek Otten - 19 May 2008 16:43 GMT

Look here:

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

Signature

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
[quoted text clipped - 3 lines]
| 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?

Reply to this Message

Don - 19 May 2008 17:12 GMT

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

> Look here:
>
[quoted text clipped - 7 lines]
> | 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?

Reply to this Message

JoeSpareBedroom - 19 May 2008 16:48 GMT

>I have created an Excel file for a group of people with one sheet
>protected.
[quoted text clipped - 5 lines]
> locked
> and you forgot the password or it has changed?

Why not ask the supervisor?

Reply to this Message

Don - 19 May 2008 17:01 GMT

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

tried combos of upper case /lower case to to luck

> >I have created an Excel file for a group of people with one sheet
> >protected.
[quoted text clipped - 7 lines]
>
> Why not ask the supervisor?

Reply to this Message