How to Unlock a Protected Excel Worksheet Without the Password
Question details
The user needs to remove worksheet protection from an Excel workbook after forgetting the protection password, without using the original password.

- Product
- Microsoft Excel worksheet opened in WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user created or received a protected Excel worksheet and now needs to edit locked cells but no longer knows the protection password.
- Observed behavior
- WPS Office or Excel prompts for a password when trying to edit protected cells or unprotect the sheet.
Confirm that you own the file or have permission to modify it, and make a backup copy before changing the file structure. Worksheet protection is separate from workbook encryption, so check that the file opens normally before editing the sheet XML.
Check the Protection Type in WPS Spreadsheets
Use this first to confirm whether the file has worksheet protection or full workbook encryption, because the XML method only works for worksheet protection.
Launch WPS Office, click Spreadsheets, then open the affected .xlsx file.
In the ribbon, click Review, then locate Protect Sheet or Unprotect Sheet.
Click Unprotect Sheet. If it asks for a password, the sheet is protected; if the file asks for a password before opening, it is encrypted and another recovery method is required.
Remove Worksheet Protection by Editing the .xlsx Sheet XML
Use this method when you have permission to modify the file and only need to remove worksheet protection from a .xlsx workbook without the password.
Open Your Recovered Excel File in WPS Spreadsheets and Keep Editing
If you frequently work with Excel files but want a lighter tool, WPS Office opens .xlsx workbooks with familiar formatting and editing tools. It is free, lightweight, and compatible with Microsoft Excel files, so you can move between apps without losing your work.
- 1. Download WPS Office: Download WPS Office from the official WPS website and install it on your Windows, macOS, Android, or iOS device.
- 2. Open your .xlsx workbook: Launch WPS Spreadsheets, click Menu or Open, and choose the recovered Excel workbook from your computer.
- 3. Edit and save in Excel format: Use the familiar ribbon tools to edit the worksheet, then save it as an .xlsx file to remain compatible with Microsoft Excel.

Frequently Asked Questions
Will this method unlock an Excel file that asks for a password when I open it?
No. This method only removes worksheet protection from the sheet XML inside an .xlsx file. If Excel or WPS Office prompts for a password before the workbook opens, the file uses workbook encryption, which requires the original password or separate recovery support.
Can WPS Spreadsheets remove worksheet protection without the password?
WPS Spreadsheets does not bypass worksheet protection passwords. You can use the XML method on a backup copy outside WPS Office, then open the unprotected workbook in WPS Spreadsheets to continue editing.
What should I check before editing the .xlsx file as a zip archive?
Confirm that you own or have permission to edit the workbook, make a backup copy, and ensure the file has the .xlsx extension. If the file is saved as .xls, save it as .xlsx first or use a compatible recovery tool.
Does removing the <sheetProtection> tag delete my data or formatting?
No. It only removes the protection settings for that worksheet. Cell data, formulas, and formatting remain intact, but you should always keep a backup in case the XML is edited incorrectly.





