Fix an Encrypted Excel Workbook That Won't Open with the Correct Password
Question details
The user needs to open an encrypted Excel workbook that no longer accepts a known password after an Office update.

- 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.
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.
Test the encrypted workbook on another computer
Use another Office installation to determine whether the issue is specific to the original computer.
Copy the workbook to another computer using a trusted drive or cloud service.
On the other computer, open Excel, select File > Open, and choose the copied workbook.
Type the known password when prompted. If the workbook opens, investigate the Office installation or settings on the original computer.
If appropriate, upload a copy to a trusted cloud location, download it again, and try opening the downloaded copy in desktop Excel.

Repair Microsoft Office on Windows
Try an Office repair if the workbook opens on another computer or the issue began after an Office update.
Consider a Windows restore point after a system change
If the issue began after a recent system change, a restore point may help reverse that change.
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.

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.




