Fix an Excel Workbook That Rejects the Correct Password
Question details
The user needs to open an Excel workbook that is rejecting a password that worked previously and determine which type of Excel protection is involved.
- Product
- Microsoft Excel workbook
- Device & OS
- not provided
- Scenario
- A user enters a previously working password when opening or editing an Excel file and needs to identify whether the password applies to the file, a worksheet, or the workbook structure.
- Observed behavior
- Excel does not accept the entered password, or the workbook opens but protected worksheet or workbook features remain unavailable.
Check that you are opening the intended copy of the workbook and entering the password manually rather than relying on autofill. Passwords are case-sensitive, and leading, trailing, or embedded spaces are treated as password characters.
Verify the Excel file-open password exactly as created
Use this when Excel asks for a password before the workbook opens or displays a password error immediately after entry.
A password required before a workbook opens is a file encryption password. It is separate from worksheet and workbook structure protection, so a sheet password will not open an encrypted file.
In File Explorer or Finder, confirm the file name, location, and modified date, then open the intended .xlsx, .xls, or .xlsm workbook in Excel.
At the Excel password prompt, type the password exactly as originally created. Verify capitalization, numbers, symbols, keyboard layout, and any spaces before or after the text.
If appropriate, try only documented variations, such as the correct keyboard language or an earlier known password. Do not repeatedly guess if the organization has password-attempt policies.
Ask the workbook owner or administrator whether the file was re-encrypted, replaced with a newer copy, or protected with a different password.
Identify worksheet and workbook structure protection
Use this when the workbook opens successfully but you cannot edit cells, unhide rows or columns, add sheets, move sheets, or change workbook structure.
Open and Manage Protected Excel Workbooks in WPS Spreadsheets
WPS Spreadsheets lets you open compatible Excel workbooks, enter authorized file passwords, and manage worksheet or workbook protection through familiar spreadsheet controls. It cannot bypass or recover an unknown encryption password, but it provides a straightforward way to work with files when you have valid access.
- 1. Open the protected workbook: Launch WPS Spreadsheets, select Menu > Open, choose the Excel workbook, and enter the authorized password when prompted.
- 2. Check sheet protection: Open the protected worksheet, select the Review tab, and choose Unprotect Sheet if you need to edit locked cells or reveal protected rows and columns.
- 3. Check workbook structure protection: On the Review tab, select Protect Workbook or Unprotect Workbook to manage restrictions on adding, deleting, moving, or unhiding worksheets.
- 4. Set a new authorized password: After opening the workbook with permission, select Menu > File > Encrypt with Password to apply or update file encryption for the saved copy.
Frequently Asked Questions
Why does Excel reject a password that used to work?
The password may be entered with different capitalization, symbols, spaces, or keyboard layout, or you may be opening a different or newer copy of the workbook. Confirm the exact file path and type the password manually.
What is the difference between an Excel file password and worksheet protection?
A file password is requested before the workbook opens and encrypts the file. Worksheet protection applies after the workbook opens and restricts actions such as editing locked cells, formatting, or unhiding rows and columns.
How do I tell whether workbook structure is protected in Excel?
Open the workbook and go to Review. If Protect Workbook indicates that protection is active or the option changes to Unprotect Workbook, the workbook structure is protected. This can prevent adding, moving, deleting, hiding, or unhiding sheets.
Can I unhide rows or columns in a protected Excel worksheet?
You need the worksheet password if protection prevents unhiding. Go to Review > Unprotect Sheet, enter the authorized password, then select adjacent rows or columns, right-click, and choose Unhide.
Can Microsoft recover a forgotten Excel encryption password?
No. Microsoft cannot recover a forgotten password used to encrypt an Excel file. You must obtain the correct password from the owner or use an available unprotected or earlier copy.
