File Cannot Open

Fix an Encrypted Excel Workbook That Won't Open with the Correct Password

Natalie TaylorNatalie Taylor Nov 14, 2026 868 views

Question details

The user needs to open an encrypted Excel workbook that no longer accepts a known password after an Office update.

Fix an Encrypted Excel Workbook That Won't Open with the Correct Password
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a password-encrypted workbook after an Office update.
Observed behavior
Excel does not open the workbook when the known password is entered.
Before you start

Check the keyboard layout, Caps Lock, and any special characters in the password. Make a copy of the workbook to use for testing and keep the original unchanged.

Solution 1Recommended

Test the encrypted workbook on another computer

Use another Office installation to determine whether the issue is specific to the original computer.

1
Transfer a copy

Copy the workbook to another computer using a trusted drive or cloud service.

2
Open it in Excel

On the other computer, open Excel, select File > Open, and choose the copied workbook.

3
Enter the password

Type the known password when prompted. If the workbook opens, investigate the Office installation or settings on the original computer.

4
Test a cloud copy

If appropriate, upload a copy to a trusted cloud location, download it again, and try opening the downloaded copy in desktop Excel.

Test the encrypted workbook on another computer
If the copy also fails: Failure on another computer does not prove the file is corrupted. Recheck the password and try an earlier copy of the workbook if one is available.
Free Microsoft Office alternative

Open Compatible Excel Workbooks with WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheets and enter the password when prompted. WPS does not repair Microsoft Office or bypass workbook encryption.

Open compatible password-protected workbooks with the correct passwordWorks with common Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface makes switching easierFree and lightweight for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel reject a password I know is correct?

Check Caps Lock, the keyboard layout, and special characters first. A file problem or an Office installation issue may also be involved; test a copy on another computer to narrow down the cause.

Can Microsoft remove the password from an encrypted workbook?

Microsoft does not provide a way to bypass or remove a forgotten password from an encrypted workbook. You need the correct password or an accessible unencrypted copy.

What should I do if the workbook fails on another computer too?

Recheck the password and try an earlier copy if available. If the file was stored in a cloud service, check its version history for an earlier version and test a downloaded copy.

Will System Restore recover a corrupted Excel file?

No. Windows System Restore can reverse certain system and program changes, but it does not restore personal files. Look for an earlier workbook copy or a cloud version instead.