Forum Discussion
How to unprotect Excel sheet if forgot the password
I found this post from search engine and tried a couple of answers shared by others in this thread. However,
most of them were not working. Fortunately, I recovered the password successfully thanks to the reply made
by LindaHamilto.https://www.softfixnow.com/how-to-unprotect-excel-sheet
P.S. for strong open password, you have to wait sometime to finally retrieve the password and unprotect the
sheet afterwards.
I successfully saved my Excel document to Google Sheets, which removed the worksheet protection. Then, I saved it back as an Excel file on my desktop.
This is the only thing on the replies that had worked. Thank you! However it will destroy any Macros you have encoded so this will only works on simple files that has a lot of formatting and data.