Md. Sourov Hossain Mithun
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.
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.
- After that click as follows: Info ➤ Enable Editing.
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.
- Next, click Option from the appeared File menu.
Consequently, the Excel Options dialog box will open up.
- After that, click as follows: Trust Center > Trust Center Settings.
It will open another dialog box.
- 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.
- 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.
