SOLVED

Unprotect workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1110261%22%20slang%3D%22en-US%22%3EUnprotect%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110261%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20was%20sent%20to%20me%20for%20my%20use%20but%20came%20password%20protected%20as%20it%20has%20sensitive%20information%20that%20was%20being%20sent%20by%20email.%20I%20have%20the%20password%20and%20have%20renamed%20and%20resaved%20the%20file%20but%20every%20time%20I%20open%20it%2C%20I%20again%20have%20to%20enter%20the%20password.%20When%20I%20go%20to%20%22Protect%20Workbook%22%20there%20is%20no%20option%20to%20unprotect%20and%20its%20the%20same%20if%20I%20look%20under%20Review%20in%20the%20ribbon.%20How%20can%20I%20get%20this%20file%20to%20stay%20unlocked%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1110261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1110291%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotect%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110291%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F519640%22%20target%3D%22_blank%22%3E%40jamieintheATX%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPassword%20protection%20sits%20in%20%22Save%20as%22.%20There%20you%20have%20%22Options...%22%20and%20you%20can%20choose%20to%20have%20no%20password.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1110300%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotect%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BBrilliant.%20That%20worked.%20Thank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497220%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotect%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497220%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B-%20where%20is%20the%20unprotect%20option%20in%20which%20tab%20-%20unable%20to%20find%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497578%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotect%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713752%22%20target%3D%22_blank%22%3E%40Balaji_B2019%3C%2FA%3E%26nbsp%3BThe%20above%20thread%20deals%20with%20removing%20or%20changing%20a%20password%20to%20open%20a%20workbook.%20There%20is%20no%20button%20for%20it.%20As%20mentioned%20above%2C%20it%20is%20part%20of%20the%20%22Save%20as%22%20process.%20But%20allow%20me%20to%20expand%20my%20previous%20response.%20On%20a%20Mac%3A%20File%2C%20Save%20as%2C%20Options.%20On%20Windows%3A%20File%2C%20Save%20as%2C%20More%20options%2C%20Tools%2C%20General%20options.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a workbook that was sent to me for my use but came password protected as it has sensitive information that was being sent by email. I have the password and have renamed and resaved the file but every time I open it, I again have to enter the password. When I go to "Protect Workbook" there is no option to unprotect and its the same if I look under Review in the ribbon. How can I get this file to stay unlocked?

4 Replies
Highlighted

@jamieintheATX 

Password protection sits in "Save as". There you have "Options..." and you can choose to have no password.

Highlighted
Solution

@Riny_van_Eekelen Brilliant. That worked. Thank you so much!

Highlighted

hi  @Riny_van_Eekelen - where is the unprotect option in which tab - unable to find it

Highlighted

@Balaji_B2019 The above thread deals with removing or changing a password to open a workbook. There is no button for it. As mentioned above, it is part of the "Save as" process. But allow me to expand my previous response. On a Mac: File, Save as, Options. On Windows: File, Save as, More options, Tools, General options.