Permission & Access Issues

How to Open an Excel File When You Forgot the Password

John Wilson Oct 16, 2026 870 views

Question details

The user needs to regain access to an encrypted Excel workbook but has forgotten the password required to open the file.

How to Open an Excel File When You Forgot the Password

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open an Excel file secured with an encryption password without knowing the credentials.
Observed behavior: Excel blocks access to the file contents and provides no native option to recover or bypass the forgotten password.

Before you start

Check any personal notebooks, web browsers, or dedicated password managers where you might have saved the credentials before attempting recovery methods.

Solution 1Recommended

Restore an Unprotected Copy from Cloud Version History

If the file is synced to cloud storage, you may be able to restore a previous version saved before the password was applied.

Cloud storage services automatically retain previous versions of your files. If the password was added recently, reverting to an older version can restore your access without needing the password.

Access Cloud Storage

Log into your OneDrive or SharePoint account via your web browser and navigate to the folder containing the encrypted Excel file.

Open Version History

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

Restore a Previous Version

Locate a version dated before you added the password protection. Click the three dots next to it and select 'Restore' or 'Download' to access the unprotected file.

Restore an Unprotected Copy from Cloud Version History

Data Loss Warning: Restoring an older version means you will lose any new data added to the workbook after that specific version was saved.

Solution 2

Search Local Backups and Alternate Locations

Locate an unprotected duplicate of the workbook on your local device, email, or backup drives.

Free Microsoft Office alternative

Manage and Secure Spreadsheets with WPS Office

Since forgotten open passwords cannot be bypassed in any standard Office software, consider managing your files with WPS Office. It provides a lightweight, highly compatible environment for all your spreadsheet needs without costly subscriptions.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open any existing unprotected Excel files seamlessly.
3. Manage Document Security: Go to the Menu, select 'Encrypt', and securely set or update passwords for your workbooks.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Built-in document encryption to securely protect your sensitive data.Free and lightweight software with a familiar, easy-to-use interface.Seamlessly migrate your existing workflows with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

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

While some third-party tools claim to remove passwords, they are often unreliable, can corrupt your file, and pose significant security risks. Microsoft strongly advises against using untrusted tools, especially for files containing sensitive data.

Will Microsoft Support help me recover my forgotten Excel password?

No. Due to strict privacy and security policies, Microsoft Support cannot retrieve, recover, or bypass passwords applied to encrypted Excel workbooks.

Is it possible to open a password-protected Excel file in Safe Mode?

No. Opening Excel in Safe Mode disables add-ins and custom settings but does not bypass file-level encryption. You still need the correct password to open the file.

What happens if I forget a 'modify' password instead of an 'open' password?

If you forget the password to modify the workbook, you can still open the file in Read-Only mode. Once open, you can simply save a copy of the workbook to a new file to bypass the editing restriction.

Document & File Issues