Excel Protected View Message: Office Has Detected a Problem with This File – 4 Solutions

 

In the image below, Excel is showing the protected view messageOffice has detected a problem with this file.”

There can be several reasons for Excel showing this alert:

  • Obtaining flies from untrustworthy sources.
  • The file is password-protected or has the Protected View option enabled.
  • It was opened from a different OneDrive storage location.
  • The file contains potential viruses.
  • A file blocker is preventing you from accessing the file.
  • Excel flags the file as invalid and prompts you to validate it.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

Solution 1 – Alter Excel Protected View Settings

Disable the Excel Protected View option.

Step 1: Go to the Options

  • Click the File tab and go to Home.
  • Select  More and click Options.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

Step 2: Use the Excel Options

  • Select Trust Center.
  • Click Trust Center Settings.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

Step 3: Disable Protected View 

  • Click Protected View.
  • Uncheck “Enable protected view for files originating from the internet”.
  • Click OK.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

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


Solution 2 – Check the Latest Version of Microsoft Excel to Update Features

Steps:

  • Go to the File tab.
  • Click  Account.
  • In Update Options, click Update Now.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

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


Solution 3 – Use the Control Panel to Repair Microsoft Excel

Step 1: Find the Programs

  • In Windows Start Menu, choose Control Panel.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

  • In Programs, click Uninstall a program.

Handy Approaches to Solve Excel Protected View Office Has Detected a Problem with This File

Step 2: Select the Application

  • Double-click Microsoft 365-en-us.
  • Click Change and select Repair.

Sample Data

Read More: How to Remove Protected View in Excel


Solution 4 – Add a New Location to Place the File

Step 1: Go to Excel Options

  • Go to Home in File
  • Click Options.

Sample Data

Step 2: Use the Excel Options

  • Select Trust Center.
  • Click Trust Center Settings.

Sample Data

Step 3: Enable the Trust Location

  • Choose Trust Locations.
  • Select Allow Trusted Locations on my network (not recommended) option.
  • Click Add new location.

Sample Data

Step 4: Browse a Location

  • Click Browse to select a folder.

Sample Data

Read More: [Solved]: Excel Opening in Protected View Stuck


Download Practice Workbook

Download the practice workbook to exercise.


Related Articles


<< Go Back to Excel Protected View | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bhubon Costa
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo