Permission & Access Issues

How to Fix Excel Worksheet Locked Without a Known Password

Huda Qurayshi Sep 25, 2026 868 views

Question details

The user needs to access and edit an Excel workbook or worksheet that has inexplicably become password-protected or locked.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to edit or open specific Excel files that randomly act as if they are protected by an unknown password.
Observed behavior: The workbook or worksheet restricts edits and prompts for a password to unprotect it, even though the owner never intentionally set encryption or password protection.

Before you start

Before attempting to remove the protection, ensure you create a backup copy of the affected Excel file to prevent accidental data loss during the troubleshooting process.

Solution 1Recommended

Remove Worksheet Protection Without a Password

Sometimes a sheet is locked accidentally without an actual password string. You can often simply turn off the protection from the Review tab.

If a workbook was locked by accident, the password field might have been left blank. In these cases, Excel allows you to remove the restriction with a single click.

Open the locked file

Double-click your affected Excel workbook to open it.

Navigate to the Review tab

Look at the top ribbon menu and click on the 'Review' tab.

Unprotect the sheet or workbook

Click on 'Unprotect Sheet' or 'Protect Workbook'. If no password was actually set, the protection will immediately be removed, and you can resume editing.

Solution 2

Copy Data to a New Workbook

If the file requires a password you do not have, copying the accessible data into a fresh file is the best workaround.

Solution 3

Check for Third-Party Software Interference

Background security or encryption software can sometimes automatically lock files without your knowledge.

Seamless Spreadsheet Management

Manage and Recover Spreadsheet Data Easily with WPS Office

If you frequently encounter formatting or protection glitches, try WPS Office. WPS Spreadsheet provides clear, easy-to-use protection features and allows you to seamlessly copy your data to new workbooks when troubleshooting locked files.

1. Install WPS Office: Download and install WPS Office Free on your device.
2. Open the file: Open the affected Excel file using WPS Spreadsheet.
3. Remove protection: Navigate to the 'Review' tab and click 'Unprotect Sheet'.
4. Migrate data if needed: If an unknown password is still required, simply highlight your visible data, copy it, and paste it into a brand new WPS Spreadsheet file.

Highly compatible with Microsoft Excel (.xlsx, .xls) formatsIntuitive 'Review' tab for managing sheet passwords and permissionsFree and lightweight alternative to heavy office suitesSeamlessly copy and paste large datasets between workbooks without lag

Frequently Asked Questions

Why did my Excel file lock itself?

This can happen due to accidental clicks on the 'Protect Sheet' feature, minor file corruption, or third-party security and encryption software automatically locking sensitive documents on your computer.

Can I recover a lost Excel password?

Standard spreadsheet programs do not provide a built-in way to recover lost passwords for security reasons. If you forget it, you will need to rely on third-party password recovery tools or copy the accessible data to a new file.

Will copying data to a new workbook save my formulas?

It depends on the level of protection. If the cells containing formulas are not hidden or locked from viewing, copying the data will usually transfer the formulas to the new workbook.

Document & File Issues