Unprotecting Spreadsheet

  • Thread starter Thread starter John
  • Start date Start date
J

John

We have a spreadsheet developed by a user about 3 years
ago. He has left the company and we need to modify the
spreadsheet. However, he as protected the cells with a
password.
Is there any way to overcome the password protection?

Thanks
 
Yes, There is an Add-in tool - called "Unprotect", (i do
not think that it is official) once you activate the add-
in whilst in excel it will create a new tool bar in
Tools "Unprotect" - click this and the add-in will
unprotect your sheet. Depending how complex the password
is, depends on how long the add-in takes to solve the
password, 27 mins is my longest!
You should be able to download the Add-in file from most
downloading programs (SuprNova.com), copy this add-in to
you Office directory, then activate it whilst running
excel.
One other way - copy the entire sheet and paste it into a
new worksheet, the protection will not carry across.
Bye..
 
Back
Top