Forum Discussion
How to unprotect Excel sheet if forgot the password
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.
Works like a charm....Thanks for your help
This was an awesome fix. I had a single sheet in multi sheet workbook copied the locked sheet to a new excel then uploaded to google doc and redownloaded and added back in then reloaded password protection.
This is the smartest way among all the solutions that I searched. I resolved my issue of the protected sheet in less than 2 minutes. Thanks.
How were you able to save it google sheets if you couldn't open the document?
The protection was just for a sheet rather than the whole document. I have the same issue, the whole document is passworded.
I'd like to think it's not possible to undo it, otherwise, what's the point? But I'll read on .. .
Thank you so much. This one worked.
