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

Get FREE Advanced Excel Exercises with Solutions!

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

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo