Trouble Shooting Excel Files Not Opening in Protected View (8 Solutions)

Solution 1 – Disable Protected View Mode in Excel to Access Files

Go to the File menu.

Select Options.

In the Excel Options dialog box, navigate to Trust Center and select Trust Center Settings.

Using Trust Center to fix Excel Cannot Open in Protected View

Choose Protected View from the Trust Center dialog box.
Uncheck all three options in the Protect View section and click OK. You should be able to open your Excel files.

Disabling Protected View Settings to Fix Excel Cannot Open in Protected View

Solution 2 – Enable Hardware Graphics Acceleration Option

Go to the File menu.

Select Options.

In the Excel Options dialog box, go to Advanced and select Display.
Check the box for Disable hardware graphics acceleration and click OK. This should allow you to open the Excel file.

Disabling Hardware Graphics Acceleration to Fix Excel Cannot Open in Protected View

Solution 3 – Adjust File Block Settings

Go to the File menu.

Select Options.

In the Excel Options dialog box, navigate to Trust Center and select Trust Center Settings.

Using Trust Center to Fix Excel Cannot Open in Protected View

Choose File Block Settings.
Uncheck all options from Excel 4 Workbooks to Excel 2 Macrosheets and Add-in Files.
Click OK. This adjustment will prevent Excel files from being blocked, allowing you to open them.

Changing File Block Settings to Fix Excel Cannot Open in Protected View

Solution 4 – Repair Faulty Office Application

If your Microsoft Office Suite is experiencing critical issues, repairing it may help open Excel files in Protected View:

Enter Control Panel in your Windows search box.
Click Open from the search results to access the Control Panel.

Using control pannel to Fix Excel Cannot Open in Protected View

Select Uninstall a program.

Choose your Microsoft Office Suite and click the Change command.

Select Quick Repair and click Repair. Once the repair process finishes, try opening your Excel files.

Repairing Office Application to Fix Excel Cannot Open in Protected View

Solution 5 – Convert Older Excel File Versions

Sometimes converting an Excel file format can resolve compatibility issues. If you’re using an older version of Excel (e.g., Excel 97 or Excel 2003), follow these steps:

Select an Excel file.
Press F2 to enable the file name.

Change the file extension from .xls to .xlsx.
Press ENTER. After converting the Excel file, attempt to open it.

Converting and Renaming Excel Files to Fix Excel Cannot Open in Protected View

Solution 6 – Update Outdated MS Office

An outdated Excel version can cause problems opening workbooks. Update Excel to the latest version:

Go to the File tab.

Select Account.

Navigate to Update Options and click on Update Now. Once the update is complete, try opening Excel workbooks.

Installing Latest MS Office Updates to Fix Excel Cannot Open in Protected View

Solution 7 – Unblock System-Blocked Excel Files

If some Excel files are blocked by the system, follow these steps:

Select all the Excel files.
Right-click on the selection.
Click Properties.
Uncheck Unblock in the General tab. After unblocking the files, try opening them.