File Cannot Open

Fix: Cannot Open Excel XLSM File After Changing Password

Huda Qurayshi Sep 28, 2026 870 views

Question details

The user is unable to open an Excel macro-enabled workbook (XLSM) after recently updating its password, likely due to a typo during the password change, an unsaved update, or forgotten credentials.

Cannot Open an XLSM File After Changing the Password

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to access a protected XLSM file immediately after setting a new password.
Observed behavior: The file refuses to open, rejecting the newly entered password as incorrect and blocking access to the data.

Before you start

Verify that your Caps Lock is turned off and ensure your keyboard language layout hasn't accidentally switched, as Excel passwords are strictly case-sensitive.

Solution 1Recommended

Verify Input Settings and Test Password Externally

Use this method to rule out typos or hidden keyboard layout issues that commonly cause password rejection.

Often, a newly changed password fails because it was originally typed while a different keyboard layout or Caps Lock state was active. Testing the password in a visible format ensures accuracy.

Open a visible text editor

Open Notepad or any basic text editor on your computer.

Type your password

Carefully type the newly changed password into the text editor so you can see exactly what is being entered.

Copy and paste into Excel

Highlight the password, copy it (Ctrl+C), open your locked XLSM file, and paste the password (Ctrl+V) into the Excel password prompt.

Verify Input Settings and Test Password Externally

Keyboard Layout Check: If you use multiple languages, check the bottom-right corner of your taskbar (Windows) to ensure the correct language layout is selected before typing.

Solution 2

Restore an Unprotected Backup or Previous Version

If the password is truly lost or corrupted, restoring a previous version is the only official way to regain access.

Free Microsoft Office alternative

Manage and Protect Your Spreadsheets Easily with WPS Office

While a lost password on a Microsoft Excel file cannot be bypassed due to strict security, you can prevent future frustrations by switching to WPS Office. It provides a lightweight, user-friendly interface with full compatibility for Microsoft Office formats, making document protection and file management completely straightforward.

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 easily open your existing Excel files, including XLSM macros.
3. Manage Passwords Securely: Go to the 'Menu' > 'Document Encryption' to safely set, change, or remove passwords on your important files.

Fully compatible with Microsoft Excel formats, including .xlsx, .xlsm, and .xlsEasy-to-use document encryption and password management toolsLightweight application that runs smoothly on almost any deviceFree to download with a highly familiar user interface for quick, seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Support reset my XLSM file password?

No. According to Microsoft's official security policy, neither Microsoft Support nor community moderators have the tools or authorization to bypass, reset, or recover passwords for encrypted Excel files.

Are there third-party tools to crack Excel passwords?

While various third-party tools on the internet claim to recover or remove Excel passwords, they are generally unsupported, carry significant malware risks, and are not recommended by official sources. Relying on regular backups is the safest practice.

Does changing the file extension help bypass the password?

No. Renaming an encrypted XLSM file to a different extension, such as ZIP or XLSX, will not remove the workbook encryption. The file's data remains encrypted until the correct password is provided.

Document & File Issues