Fix Excel Crashing When Opening a Password-Protected Workbook
Question details
The user needs to open a password-protected workbook without Excel crashing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening an encrypted Excel workbook with its password.
- Observed behavior
- Excel may crash while opening the password-protected file.
Confirm that you have the workbook password and note whether the crash occurs before or after entering it. The troubleshooting steps below apply to Excel on Windows; menu names can vary by Office version.
Test Excel in Safe Mode and disable COM add-ins
Use Safe Mode to check whether an add-in or startup customization is causing the crash.
Press Windows + R, enter excel /safe, and select OK. In Excel, use File > Open to try the protected workbook and enter its password.
If the workbook opens in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Select COM Add-ins in the Manage box, select Go, clear the add-in checkboxes, and select OK.
Restart Excel and open the workbook again. If it works, return to File > Options > Add-ins > COM Add-ins and enable add-ins one at a time, restarting and testing after each change.

Check Excel startup files and test a workbook copy
Use this approach if Excel still crashes or the issue may be specific to the original file or its location.
Update and repair Microsoft Office
Repair Office components if the crash continues after testing add-ins and startup files.
Try WPS Spreadsheet as an Excel alternative
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easy to move between applications. It does not repair Excel; opening a particular encrypted workbook depends on its protection and compatibility.

Frequently Asked Questions
Why does Excel open the workbook in Safe Mode but crash normally?
An add-in or startup customization may be responsible. Go to File > Options > Add-ins, select COM Add-ins under Manage, and disable them before testing again.
Does renaming the workbook remove its password?
No. Renaming or copying the workbook does not remove encryption. You still need its password to open it.
Where is Excel's startup folder on Windows?
Press Windows + R and enter %appdata%\Microsoft\Excel\XLSTART. Also check File > Options > Advanced > General for an alternative startup location.
What should I do if Quick Repair does not stop the crash?
In Windows Settings > Apps > Installed apps, select Modify for Microsoft 365 or Office, then choose Online Repair. You need an internet connection.
Can WPS Office open an encrypted Excel workbook?
WPS Spreadsheet can open compatible password-protected workbooks when you have the password, but support can vary with the workbook's encryption and protection features.




