How to Remove Protected View in Excel (3 Quick Methods)

After downloading or collecting an Excel file from any other source, Excel opens the file in Protected View by default to avoid the risk of being affected by the virus. But if you want to keep off that default feature, Excel has some ways to do it. So in this article, I’ll show those 3 simple ways of Excel to remove Protected Views.


How to Remove Protected View in Excel: 3 Quick Methods

To explore the methods, we’ll use the following dataset representing the hourly rate of some content writers who worked in ExcelDemy.


1. Remove Protected View by Clicking Enable Editing Button in Excel

First, we’ll learn the most common and easy method to erase the Protected View in Excel. It’s not a permanent method, you will have to do it every single time when you download or collect Excel files from other sources.

Step:

  • Click the Enable Editing Button under the ribbon bar that you will get after opening a downloaded or collected Excel file.

Remove Protected View by Clicking Enable Editing Button in Excel

Now see, the Protected View mode is removed.

Read More: Cannot Edit Excel File in Protected View


2. Clear Protected View Using Info Option

We can do the same operation in a bit different way, there is an option in the File menu that can remove the Protected View. It’s the same command that we learned in the first method just placed in a different place.

Steps:

  • Click on the File tab.

Clear Protected View Using Info Option

  • After that click as follows: Info ➤ Enable Editing.

Clear Protected View Using Info Option

Then you will get that Excel has removed the Protected View.

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


3. Permanently Remove Protected View from Trust Center Settings in Excel

The previous method was a temporary solution, in this section, we’ll learn a way that will permanently remove the Protected View. When you are using an AntiVirus to download or collect files from a trusted source then this method will be really useful for you.

Steps:

  • Click on the File tab.

Permanently Remove Protected View from Trust Center Settings in Excel

  • Next, click Option from the appeared File menu.

Consequently, the Excel Options dialog box will open up.

Permanently Remove Protected View from Trust Center Settings in Excel

  • After that, click as follows: Trust Center > Trust Center Settings.

It will open another dialog box.

Permanently Remove Protected View from Trust Center Settings in Excel

  • At this moment, Click Protected View from the left menu.
  • Then unmark all options from the Protected View section.
  • Press OK and it will take you back to the previous dialog box.

Permanently Remove Protected View from Trust Center Settings in Excel

  • Nothing to do anymore, just press OK.

Then if you open an Excel file downloaded or collected from anywhere, you will never face the Protected View. I opened a downloaded file after applying this method and didn’t face Protected View.

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


Download Practice Workbook

You can download the free Excel template from here and practice independently.


Conclusion

I hope the procedures described above will be good enough to remove the protected view in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo