Forum Discussion
Best Excel password remover for Mac as I forgot Excel password
I set a password on an important Excel spreadsheet a while back on my mac and completely forgot what it was. The file has data that's urgently needed and there's no unprotected backup copy saved anyw...
If the file only has editing restrictions (not an open-password) and you're the owner but forgot the specific unprotect password.
How to remove password from excel on mac
1. Duplicate the file first as a backup.
2. Rename the copy's extension from .xlsx to .zip.
3. Unzip it, then open the xl/worksheets/sheet1.xml (or relevant sheet file) in a text editor.
4. Find and delete the <sheetProtection .../> tag.
5. Re-zip the folder and rename it back to .xlsx.
This only works for sheet/workbook protection (not an open-password), and you must have legitimate rights to the file.