File Cannot Open

How to Fix Password-Protected Excel Files Repeatedly Reopening

Algirdas Jasaitis Oct 7, 2026 871 views

Question details

The user is unable to access an encrypted workbook because Excel continuously prompts for the password or reopens the dialog.

How to Fix Password-Protected Excel Files Repeatedly Reopening

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open and view a password-protected spreadsheet for editing or reviewing.
Observed behavior: Excel repeatedly displays the Open dialog in an endless loop when trying to access the password-protected file, preventing the user from viewing the document content.

Before you start

Verify that you are entering the correct password for the workbook, and temporarily disable any recently updated third-party antivirus software that might be continuously scanning encrypted files upon opening.

Solution 1Recommended

Disable Add-ins and Adjust Advanced Options

Running Excel in Safe Mode and disabling third-party add-ins can resolve conflicts that cause the Open dialog to loop.

Third-party COM add-ins often interfere with Excel's file handling processes, especially when dealing with encrypted documents. Bypassing these add-ins helps isolate the root cause.

Start Excel in Safe Mode

Press the Windows key + R to open the Run dialog box. Type 'excel /safe' and press Enter to launch Excel without any add-ins.

Access Excel Options

Click on 'File' in the top-left corner, then select 'Options' at the bottom of the menu. Navigate to the 'Advanced' tab to review your file handling settings.

Disable COM Add-ins

In the Excel Options window, click on 'Add-ins' on the left sidebar. At the bottom, change the Manage dropdown to 'COM Add-ins' and click 'Go'. Uncheck all add-ins in the list and click 'OK'.

Disable Add-ins and Adjust Advanced Options

Options Menu Disabled: If you notice that most categories under File > Options are greyed out, your organization's IT group policies are likely restricting you from altering application settings. You may need to contact your IT administrator.

Solution 2

Repair the Microsoft Office Installation

Running an Online Repair can fix corrupted application files or broken file associations that are preventing protected files from loading properly.

Free Microsoft Office alternative

Open Protected Spreadsheets Seamlessly with WPS Office

If Microsoft Excel continues to loop the Open dialog due to persistent application bugs, try WPS Office. It provides a lightweight, highly compatible, and free alternative to easily view and edit your password-protected XLSX workbooks.

1. Install WPS Office: Download and install WPS Office for free from the official website.
2. Open the Spreadsheet: Launch WPS Spreadsheets, click 'Open', and select your password-protected Excel file.
3. Enter Password: Input your document password when prompted to immediately access and edit your data without looping dialogs.

Highly compatible with Microsoft Excel formats (.xlsx, .xls) and encrypted workbooks.Free and lightweight, avoiding the heavy add-in loops common in standard Office installations.Familiar user interface ensures a seamless transition with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why are the Advanced options greyed out in my Excel settings?

Advanced options can be disabled or greyed out if your workplace or school IT administrator has applied organizational group policies that restrict users from modifying application settings.

Will removing third-party add-ins delete my Excel data?

No. Disabling or removing COM add-ins only turns off additional features or integrations provided by external software. It does not delete, alter, or corrupt any of your actual workbook data.

How can I check if the looping issue is isolated to just one file?

Create a new, blank workbook in Excel. Go to File > Info > Protect Workbook > Encrypt with Password. Save it with a simple password, close it, and try reopening it. If this new file opens normally, your original file might be corrupted rather than the Excel application.

Document & File Issues