SOLVED

I have a password protected worksheet I do not remember the password for. How do I unprotect?

%3CLINGO-SUB%20id%3D%22lingo-sub-1247456%22%20slang%3D%22en-US%22%3EI%20have%20a%20password%20protected%20worksheet%20I%20do%20not%20remember%20the%20password%20for.%20How%20do%20I%20unprotect%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247456%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20password%20protected%20worksheet%20that%20I%20do%20not%20remember%20the%20password%20for.%26nbsp%3B%20How%20do%20I%20unprotect%20the%20sheet%20for%20editing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1247456%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249347%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20a%20password%20protected%20worksheet%20I%20do%20not%20remember%20the%20password%20for.%20How%20do%20I%20unprotect%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249347%22%20slang%3D%22en-US%22%3EOfficially%2C%20there's%20no%20way%20to%20do%20this.%20There%20are%20some%20macros%20and%20services%20advertised%20out%20there%20that%20claim%20to%20break%20sheet%20protection%2C%20and%20some%20may%20do%2C%20but%20take%20caution%20before%20running%20unknown%20code%20on%20your%20workbook.%20There%20is%20no%20password%20recovery%20option%20built%20in%20to%20Excel.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249491%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20a%20password%20protected%20worksheet%20I%20do%20not%20remember%20the%20password%20for.%20How%20do%20I%20unprotect%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249491%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544433%22%20target%3D%22_blank%22%3E%40Savia%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20advice%2C%20however%2C%20I%20decided%20to%20make%20a%20copy%20of%20my%20original%20file%20to%20prevent%20against%20losing%20anything%20before%20I%20attempted%20to%20do%20it%20on%20my%20own.%26nbsp%3B%20After%20a%20search%20query%20related%20to%20the%20subject%2C%26nbsp%3B%20I%20found%20that%20I%20was%20able%20to%20work%20through%20a%20help%20screen%20to%20find%20a%20solution%20that%20actually%20worked.%26nbsp%3B%20I%20found%20a%20site%20that%20spoke%20about%20using%20a%20VBA%20code%20to%20unlock%20the%20password.%3C%2FP%3E%3CP%3EIt%20walked%20me%20through%20the%20steps%20fairly%20easily%20and%20I%20was%20able%20to%20copy%20the%20code%20right%20from%20the%20screen%20as%20instructed%20and%20paste%20it%20onto%20my%20own%20screen.%26nbsp%3B%20After%20running%20the%20code%20(I%20needed%20to%20do%20this%20a%20couple%20of%20times%20because%20I%20wasn't%20sure%20how%20to%20actually%20run%20the%20code%20on%20my%20computer%20at%20first)%20it%20actually%20provided%20me%20with%20a%20temporary%20unlock%20password%2C%20AAAAAAAAAA%2C%20which%20I%20used%2C%20and%20was%20actually%20impressed%20that%20it%20worked.%3C%2FP%3E%3CP%3EI%20have%20since%20protected%20the%20sheet%20again%20and%20this%20time%20chose%20a%20unique%20password.%26nbsp%3B%20To%20remember%20it%2C%20I%20have%20typed%20in%20a%20hint%20outside%20of%20the%20spreadsheet%20that%20will%20help%20me%20next%20time%20I%20need%20to%20unlock%20the%20spreadsheet%20to%20update%20it%20(eg.%20my%20favorite%20teacher%20in%20high%20school).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDave%20Diesel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379611%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20a%20password%20protected%20worksheet%20I%20do%20not%20remember%20the%20password%20for.%20How%20do%20I%20unprotect%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379611%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%3C%2FP%3E%3CP%3Esince%20i%20can'%20find%20an%26nbsp%3B%20easy%20solution%26nbsp%3B%20do%20i%20need%20to%26nbsp%3B%20%26nbsp%3Bcopy-paste%26nbsp%3B%20my%20previous%20excel%20worksheet%20and%20create%20a%20new%20one%26nbsp%3B%20(unprotected)%3F%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379641%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20a%20password%20protected%20worksheet%20I%20do%20not%20remember%20the%20password%20for.%20How%20do%20I%20unprotect%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F591569%22%20target%3D%22_blank%22%3E%40ddiesel52%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20cannot%20open%20a%20password%20protected%20sheet%20without%20pasting%20in%20the%20password.%3C%2FP%3E%3CP%3EThere%20are%20tools%20that%20force%20open%20a%20sheet%20but%20they%20are%20not%20reliable%20to%20be%20used%20on%20your%20device.%3C%2FP%3E%3CP%3EUnfortunately%2C%20you%20shall%20have%20to%20remember%20the%20password.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards.%3C%2FP%3E%3CP%3EAdmin%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.o365cloudexperts.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.o365cloudexperts.com%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379688%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20a%20password%20protected%20worksheet%20I%20do%20not%20remember%20the%20password%20for.%20How%20do%20I%20unprotect%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F644179%22%20target%3D%22_blank%22%3E%40Abigail05%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20my%20issue%20is%20similar%20to%20previous%20one%2C%20but%20I%20know%20I%20haven't%20password%20protected%20a%20sheet%2C%26nbsp%3B%20how%20do%20I%20unprotect%20it%20when%20its%20asking%20for%20password%2C%20to%20which%20I%20haven't%20got%20or%20ever%20had....%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a password protected worksheet that I do not remember the password for.  How do I unprotect the sheet for editing?

 

5 Replies
Highlighted
Best Response confirmed by ddiesel52 (New Contributor)
Solution
Officially, there's no way to do this. There are some macros and services advertised out there that claim to break sheet protection, and some may do, but take caution before running unknown code on your workbook. There is no password recovery option built in to Excel.
Highlighted

@Savia , 

Thank you for the advice, however, I decided to make a copy of my original file to prevent against losing anything before I attempted to do it on my own.  After a search query related to the subject,  I found that I was able to work through a help screen to find a solution that actually worked.  I found a site that spoke about using a VBA code to unlock the password.

It walked me through the steps fairly easily and I was able to copy the code right from the screen as instructed and paste it onto my own screen.  After running the code (I needed to do this a couple of times because I wasn't sure how to actually run the code on my computer at first) it actually provided me with a temporary unlock password, AAAAAAAAAA, which I used, and was actually impressed that it worked.

I have since protected the sheet again and this time chose a unique password.  To remember it, I have typed in a hint outside of the spreadsheet that will help me next time I need to unlock the spreadsheet to update it (eg. my favorite teacher in high school). 

 

Thanks again,

 

Dave Diesel

Highlighted

Dear all

since i can' find an  easy solution  do i need to   copy-paste  my previous excel worksheet and create a new one  (unprotected)? 

thanks  

Highlighted

@ddiesel52 

You cannot open a password protected sheet without pasting in the password.

There are tools that force open a sheet but they are not reliable to be used on your device.

Unfortunately, you shall have to remember the password.

 

 

Regards.

Admin

https://www.o365cloudexperts.com/

Highlighted

@Abigail05 

Hi my issue is similar to previous one, but I know I haven't password protected a sheet,  how do I unprotect it when its asking for password, to which I haven't got or ever had....