[Fixed] Excel Protected View Editing This File Type Is Not Allowed

While exploring Excel, you may encounter different types of errors, and opening and editing files in Protected View is also a challenge. In this article, you will learn 2 methods to fix the “Editing this file type is not allowed” error in Excel Protected View.


What Is ‘Editing This File Type Is Not Allowed’ Error in Excel?

Suppose, you used the Protect Workbook feature to encrypt an Excel file using an Excel program order than Excel 2010. Now, you opened the protected workbook in a recent version of Excel such as Excel 2010 and onwards.

In such cases, you will see an error “Protected View Editing this file type is not allowed due to your policy settings. Click for more details.”

‘Editing This File Type Is Not Allowed’ Error in Excel


2 Solutions to Fix ‘Protected View Editing This File Type Is Not Allowed’ Error in Excel

1. Disabling Protected View Settings

You can disable the Protect View mode to fix the error.

For that,

❶ Go to the File tab.

❷ Select Options.

Excel Options dialog box will pop up.

❸ Select Trust Center > Trust Center Settings.

Using Trust Center to Fix ‘Editing This File Type Is Not Allowed’ Error

The Trust Center dialog box will appear.

❹ Go to the Protected View option.

❺ Now, uncheck the following three options from the Protected View section.

  • Enable Protected View for files originating from the Internet

Disabling this option allows Excel to open files downloaded from the internet.

  • Enable Protected View for files that are located in potentially unsafe locations

Unchecking this option allows Excel to open files saved in any location.

  • Enable Protected View for Outlook attachments

Deselecting this option allows Excel to open files retrieved from email attachments.

❻ After that, click OK.

Disabling Protected View Settings to Fix ‘Editing This File Type Is Not Allowed’ Error

Now the Protected View mode will be disabled. So, you can access the file having the error.


2. Changing File Block Settings to Fix ‘Editing This File Type Is Not Allowed’ Error

If the previous method doesn’t solve the problem, you can change the File Block Settings. I hope this might work for you.

Here’s how to do that,

❶ Go to File first.

❷ Then select Options.

Excel Options dialog box will appear.

❸ Now go to Trust Center > Trust Center Settings.

Using Trust center to Fix ‘Editing This File Type Is Not Allowed’ Error

The Trust Center dialog will appear.

❹ Go to File Block Settings.

❺ After that uncheck the following options.

  • Excel 4 Workbooks
  • Excel 4 Worksheets
  • Excel 3 Worksheets
  • Excel 2 Worksheets
  • Excel 4 Macrosheets and Add-in Files
  • Excel 3 Macrosheets and Add-in Files
  • Excel 2 Macrosheets and Add-in Files

❻ Then hit OK.

Changing File Block Settings to Fix ‘Editing This File Type Is Not Allowed’ Error

Now, try opening the Excel file saved in Protected View. Hope you can open the file without facing the error anymore.


Conclusion

To sum up, we have discussed 2 ways to fix the error “Protected View Editing this file type is not allowed due to your policy settings. Click for more details.” in Excel. 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