Forum Discussion
5for17
Apr 16, 2026Copper Contributor
Forgot Excel Password
Hi how can i recover an excel workbook where I have forgotten the password?
carlwi3a
Apr 17, 2026Copper Contributor
If you are able to download the Excel file, you can remove the password.
- Download a copy of the Excel file.
- Rename your .xlsx (or .xlsm) file to .zip.
- Extract/unzip it.
- Go to the xl/worksheets/ folder.
- Open the relevant sheetN.xml file in a text editor (Notepad++, VS Code, etc.).
- Search for sheetProtection.
- Delete the whole tag (it looks something like <sheetProtection algorithmName="..." password="..." ... /> or with hashValue/saltValue).
If the password protects the workbook structure (not an individual sheet), then the file is xl/workbook.xml and you delete the entire tag using the exact same process.
- Save the file.
- Zip the entire folder, not the contents.
- Rename the .zip back to .xlsx.
- Open in Excel and enjoy.