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.”
Read More: Cannot Edit Excel File in Protected View
Excel Protected View Editing This File Type Is Not Allowed: 2 Solutions
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.
The Excel Options dialog box will pop up.
❸ Select Trust Center > Trust Center Settings.
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
Unselecting this option allows Excel to open files retrieved from email attachments.
❻ After that, click OK.
Now the Protected View mode will be disabled. So, you can access the file having the error.
Read More: [Fixed] Excel Cannot Open in Protected View
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.
The Excel Options dialog box will appear.
❸ Now go to Trust Center > Trust Center Settings.
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.
Now, try opening the Excel file saved in Protected View. Hope you can open the file without facing the error anymore.
Read More: [Solved]: Excel Protected View Office Has Detected a Problem with This File
Conclusion
To sum up, we have discussed 2 ways to fix the error “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 to 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.
Related Articles
- How to Enable Editing in Excel Protected View
- [Solved]: Excel Opening in Protected View Stuck
- How to Remove Protected View in Excel
<< Go Back to Excel Protected View | Excel Files | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
