Excel 07 Password Protection

[LW8801]

How do I remove the password to open up an Excel 2007 spreadsheet?

 

[dave3009]

Once you have the document open go to the Office button>>Prepare>>delete the existing password>>Save.

We don't have a solution for bypassing the protection on a workbook that you have misplaced/forgotten the password for.

Regards

 

[LW8801]

I'm using Excel 2007 on Windows XP. When I follow your instructions, I don't see where I can delete the existing password.

 

[dave3009]

Opps that should be Office button>>Prepare>>Encrypt Document, delete the existing password then save the document.

 

[LW8801]

OK. Apparently I'm doing something wrong because when I go into Office>>Prepare>>Encrypt Document, a box comes up wanting me to enter a password

 

[LW8801]

I've done this before on the very same worksheet (different month) and I can't remember how the heck I did it!

 

[dave3009]

Maybe in the Save As dialogue box, though Microsoft suggest the same route as I have.

http://office.microsoft.com/en-us/h...-workbooks-and-presentations-HA010148333.aspx

 

[jasonb75]

Open the workbook then go to the "Review" tab on the ribbon and click "unprotect sheet".

Enter the password.