[Fixed] Excel Cannot Open in Protected View (8 Solutions)

An Excel workbook having in Protected View mode only enables users to read the workbook but doesn’t provide any access to edit or manipulate any data. But when Excel cannot open in Protected View, it’s certain that there’s something that needs to be tweaked. In this article, you will get 8 solutions to fix Excel that cannot open in Protected View error.


8 Solutions Regarding Excel Cannot Open in Protected View

1. Disabling Protected View Settings

The first thing you can do is disable the Protected View mode to access an Excel file.

For that,

❶ Go to File.

❷ Then select Options.

❸ Go to Trust CenterTrust Center Settings in the Excel Options dialog box.

Using Trust Center to fix Excel Cannot Open in Protected View

❹ Select Protected View from the Trust Center dialog box.

❺ Uncheck all 3 options in the Protect View section and hit OK.

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

Now, you can open your Excel files.


2. Disabling Hardware Graphics Acceleration

If the previous method doesn’t work for you, then try this.

❶ Go to the File tab.

❷ Select Options.

❸ Go to Advanced Display in the Excel Options dialog box.

❹ Check ‘Disable hardware graphics acceleration’ and hit OK.

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

Now, you will be able to open the Excel file.


3. Changing File Block Settings

You can also change the File Block Settings to open Excel workbooks set in Protected View mode.

For that,

❶ Go to File.

❷ Then select Options.

❸ Go to Trust Center Trust Center Settings in the Excel Options dialog box.

Using Trust Center to Fix Excel Cannot Open in Protected View

❹ Select File Block Settings.

❺ After that, uncheck all the options from Excel 4 Workbooks to Excel 2 Macrosheets and Add-in Files.

❻ Then just hit OK.

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

This will prevent Excel files from blocking and you can easily open them.


4. Repairing Office Application

If your Microsoft Office Suite itself is suffering from any critical issue, then repairing it can help open Excel files in Protected View.

To repair,

❶ Type Control Panel in your windows search box.

❷ From the search result, click Open to open the Control Panel.

Using control pannel to Fix Excel Cannot Open in Protected View

❸ Then click Uninstall a program.

❹ Select your Microsoft Office Suite and hit the Change command.

❺ After that, select Quick Repair and hit Repair.

Repairing Office Application to Fix Excel Cannot Open in Protected View

When the repairing process finishes, you can try open your Excel files.


5. Converting and Renaming Excel Files

Sometimes converting an Excel file format can really help. If you are using an older version of Excel such as Excel 97 or Excel 2003, you face problems opening them in the latest version of Microsoft Excel.

However, you can convert an old version of Excel to a new version just by renaming the file.

For that,

❶ Select an Excel file.

❷ Then press the F2 button to enable remain the file name.

❸ Change the file extension from .xls to .xlsx.

❹ And hit ENTER.

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

After converting the Excel file you can try opening it.


6. Installing Latest MS Office to Open in Protected View

An outdated Excel can also cause trouble opening an Excel workbook.

Updating your Excel to the latest version can help you.

To update,

❶ Go to the File tab.

❷ Select Account.

❸ Go to Update OptionsUpdate Now.

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

After the update is done, you can open Excel workbooks.


7. Unblocking File to Fix Cannot Open in Protected View

If you already have some Excel files blocked by the system, you cannot open them.

To unblock the Excel files,

❶ Select all the Excel files first.

❷ Right-click on the selection.

❸ Click Properties.

❹ Then uncheck Unblock in the General tab.

After unblocking the Excel files, you can try opening them.


8. Updating DisplayLink Driver

If you display drivers are outdated, they can also be responsible for your Excel not capable of opening a file in Protected View.

So it’s better to update your DisplayLink drivers.


Conclusion

To sum up, we have discussed 8 solutions regarding Excel cannot open in protected view. You are recommended to download the practice workbook attached with this article and practice all the methods. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo