Permission & Access Issues

How to Handle a Forgotten Excel Workbook Password

John Wilson Sep 27, 2026 869 views

Question details

The user wants to know if there is a way to remove, bypass, or recover a forgotten password required to open an Excel workbook.

Can You Remove or Bypass a Forgotten Excel Workbook Password?

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open a password-protected Excel file without knowing the required open password.
Observed behavior: Excel blocks access to the file's contents completely and does not provide any built-in or supported method to bypass or reset the forgotten open password.

Before you start

Verify that your Caps Lock key was not accidentally turned on when you created the password, as Excel passwords are case-sensitive. You should also check if you have any unprotected backup copies saved on an external drive or cloud storage.

Solution 1Recommended

Restore a Previous Unprotected Version

If your file was synced to cloud storage before the password was applied, you can restore an older, unprotected version of the workbook.

Cloud storage services like OneDrive, SharePoint, or Google Drive keep a history of file changes. Restoring an earlier version might result in some recent data loss, but it allows you to regain access to the bulk of your spreadsheet.

Locate the file in your cloud storage

Open your web browser and navigate to OneDrive or SharePoint where the encrypted Excel file is saved.

Access Version History

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

Restore an older version

Review the list of previous versions by date. Click the three dots next to a version saved before you added the password, and select 'Restore' or 'Download'.

Data Loss Warning: Any changes made to the workbook after the restored version was saved will be lost. Only use this method if the data inside the file is more critical than the recent edits.

Solution 2

Contact the Workbook Owner or Administrator

If you did not create the workbook yourself, the original creator or your IT department might have the password or an original, unprotected copy.

Free Microsoft Office alternative

Try WPS Office for Secure and Accessible Spreadsheets

While a forgotten password on a strictly encrypted Excel file cannot be bypassed due to encryption limits, switching to WPS Office provides a lightweight, highly compatible, and user-friendly environment for managing your future spreadsheets. WPS Office fully supports Microsoft Office file formats and offers robust, reliable security features to safely protect your workbooks without unnecessary complexity.

1. Download WPS Office: Visit the official WPS Office website and click the download button for your operating system.
2. Install the Software: Run the downloaded installer and follow the on-screen instructions to complete the setup.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and easily open your existing .xlsx or .csv files to continue your work seamlessly.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) formatsLightweight application that runs smoothly on most devicesFamiliar user interface for quick adoptionFree alternative to expensive office suitesReliable document encryption to protect your sensitive data securely

microsoft office alternative - wps office

Frequently Asked Questions

Are there any legitimate third-party tools to remove an Excel workbook password?

Modern Excel files (.xlsx) use strong AES encryption that cannot be easily broken or bypassed. While some third-party tools claim to recover passwords via brute-force attacks, they are often ineffective for long passwords and can pose serious malware risks to your computer.

Is there a difference between an open password and a sheet protection password?

Yes. A workbook open password encrypts the entire file, making it unreadable without the password. A sheet protection password only restricts certain actions (like editing specific cells) but still allows you to open the file and view the data.

Can I bypass the password by changing the Excel file extension to .zip?

No. Changing the file extension to .zip and editing the internal XML files only works for removing sheet-level protection or workbook structure protection. It does not work for an encrypted workbook open password, as the file contents remain completely scrambled.

Will Microsoft Support help me recover a forgotten Excel password?

No. Microsoft Support policies strictly prohibit their support engineers from assisting users with bypassing, removing, or recovering lost passwords for encrypted files due to security and privacy liabilities.

Document & File Issues