Forum Discussion
How to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if...
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.