Permission & Access Issues

How to Remove Excel Worksheet Protection When the Password Is Forgotten

WPS Editor Sep 25, 2026 870 views

Question details

The user needs to remove or bypass worksheet or workbook protection in Excel after forgetting the access password.

How to Remove Excel Worksheet Protection When the Password Is Forgotten

Product: Excel
Device & OS: not provided
Scenario: Attempting to access, edit, or modify an Excel file that is restricted by a forgotten password.
Observed behavior: The user is locked out of editing the worksheet or viewing the file and is seeking safe ways to recover or remove the protection.

Before you start

Determine whether the password restricts opening the entire workbook or just prevents editing specific worksheets, as this will dictate your recovery options.

Solution 1Recommended

Restore a Previous Unprotected Version

If you have backups or cloud version history enabled, you can revert to a version of the file before the password was applied.

Cloud storage services like OneDrive or Google Drive automatically save older versions of your files. Restoring a version from before the protection was enabled is the safest way to regain access without risking data corruption.

Locate the file in cloud storage

Navigate to your Excel file in your cloud storage web interface (e.g., OneDrive or SharePoint).

Access Version History

Right-click the locked Excel file and select 'Version history' from the context menu.

Select an older version

Browse the list of saved versions on the right-side panel and look for a timestamp dated before the worksheet protection was added.

Restore the file

Click the three dots next to the chosen version and click 'Restore' or 'Download' to recover the unprotected workbook.

Data Loss Warning: Restoring an older version will discard any data entered after that specific backup was created.

Solution 2

Request Access from the Original File Owner

For shared corporate documents, the most reliable method is to ask the administrator or original creator to remove the protection.

Free Microsoft Office alternative

Manage Your Spreadsheets Securely with WPS Office

Looking for a reliable, easy-to-use spreadsheet tool? WPS Office is a lightweight and powerful alternative that makes protecting, unprotecting, and managing your worksheets simple and intuitive, without the steep subscription costs.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsIntuitive document encryption and worksheet protection settingsLightweight architecture ensures fast loading of large, complex workbooksFree to use with a familiar, tabbed user interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Can I use third-party software to crack an Excel password?

It is highly discouraged. Many third-party unlocking tools available online pose significant security risks, may contain malware, or violate your organization's data privacy policies. Always rely on official recovery methods or backups.

What is the difference between workbook and worksheet protection?

Worksheet protection locks specific cells from being edited or formatted on a single sheet. Workbook protection prevents structural changes, such as adding, deleting, or hiding sheets. An 'open password' prevents the entire file from being viewed.

Is it possible to copy data from a protected worksheet?

If the author allowed cell selection when applying the protection, you can highlight the cells, press Ctrl+C, and paste the data into a brand-new, unprotected workbook to regain editing capabilities.

Document & File Issues