SOLVED

Can open a protected workbook with password but cannot unprotect it -says password incorrect

%3CLINGO-SUB%20id%3D%22lingo-sub-2246746%22%20slang%3D%22en-US%22%3ECan%20open%20a%20protected%20workbook%20with%20password%20but%20cannot%20unprotect%20it%20-says%20password%20incorrect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246746%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20file%20that%20has%20been%20workbook%20protected.%20I%20input%20the%20password%20and%20it%20opens%20it%20up%20(if%20i%20type%20the%20password%20wrong%20it%20doesn't%20open%20up%20as%20expected).%20But%20I%20wish%20to%20unprotect%20the%20workbook%20so%20I%20click%20review%20protect%20workbook%20and%20the%20pop%20up%20comes%20up%20%22unprotect%20workbook%22%2C%20I%20enter%20the%20same%20password%20and%20it%20says%20the%20password%20is%20incorrect.%20I%20have%20even%20copied%20and%20pasted%20it%20so%20it%20allows%20me%20to%20open%20the%20workbook%20just%20not%20unprotect%20it.%20Any%20ideas%20how%20to%20remove%20the%20password%20please%3F%20I%20have%20office%20365%20and%20the%20workbook%20I%20have%20is%20opened%20in%20the%20desktop%20version.%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2246746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

I have a file that has been workbook protected. I input the password and it opens it up (if i type the password wrong it doesn't open up as expected). But I wish to unprotect the workbook so I click review protect workbook and the pop up comes up "unprotect workbook", I enter the same password and it says the password is incorrect. I have even copied and pasted it so it allows me to open the workbook just not unprotect it. Any ideas how to remove the password please? I have office 365 and the workbook I have is opened in the desktop version.

Many thanks.

2 Replies
best response confirmed by dizzimare38 (New Contributor)
Solution

@dizzimare38

The password required to open a workbook is specified in the Save As dialog.

The password required to unprotect the workbook is specified in Review > Protect Workbook.

These passwords are not related, so they are usually not the same.

You'll have to know the password specified in Review > Protect Workbook to unprotect it.

@Hans Vogelaar that makes sense thank you. Hadnt thought of that. Your help is greatly appreciated! Thank you.