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

Solution 1 – Disabling Protected View Settings

❶ Go to the File tab.

❷ Select Options.

The 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.

❺ 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.

❻ Click OK.

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

The Protected View mode is now disabled.

Read More: [Fixed] Excel Cannot Open in Protected View


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

❶ Go to File.

❷ Select Options.

The Excel Options dialog box will pop up.

❸ 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 pop up.

❹ Go to File Block Settings.

❺ 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

❻ Hit OK.

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

The Excel file saved in Protected View will now open.

Read More: [Solved]: Excel Protected View Office Has Detected a Problem with This File


Related Articles


<< Go Back to Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo