How to Remove Protected View in Microsoft Excel – Maybe some of us have experienced problems when opening Excel files, with various extensions. One problem that may occur quite often is the appearance of notification messages at the bottom of the ribbon. If, for example, you feel you are experiencing this problem, perhaps you can overcome it using several methods which we will discuss this time.
The notification is Protected view. And as users, maybe sometimes we feel that for example, this is not a serious problem. Because by just clicking on the text enable editing, the document will still be able to be opened and edited as needed. And actually that is one solution that you can do.
It’s just that some others might feel lazy if, for example, they have to click enable editing every time they open a document. If you are one of those people who is too lazy to click back and forth to enable editing every time you open the file, then you can do the following to remove Protected View in Microsoft Excel.
How to Remove Protected View in Microsoft Excel
Before we discuss how to remove Protected view in Microsoft Excel, we will first discuss what the function of Protected view itself is. So you need to know that, for example, Protected View is one of the features provided by Microsoft in their Microsoft Office. And this feature has been present since 2010.
That means this feature is more than 10 years old. And if we pay attention, Microsoft continues to make improvements and develop various features. Microsoft Excel’s Protected View is no exception. As the name suggests, the Protected view feature acts as a protector against possible viruses and bad things in documents.
So this feature is actually quite helpful and quite useful. Because later you won’t only be able to view files or documents using reading mode. But it also allows you to edit the file using protection mode. Usually this information will appear when you get the file from the internet or a document sent by someone else.
Usually the message that appears to warn you of the security protection of the file is displayed in different writing forms. The following are several examples of the display of protection information that we get from the internet.
Be careful – email attachments can contain viruses. Unless you need to edit, it’s safer to stay in Protected View. Be careful – email attachments can contain viruses. If you don’t need to edit, it’s safer to stay in Protected View.
Be careful – This file is from someone else’s OneDrive. Unless you trust this person and want to continue collaborating with them, it is safer to stay in Protected View. Be careful – This file is from someone else’s OneDrive. If you don’t trust this person and want to continue collaborating with them, it’s safer to stay in Protected View.
Be careful – files from the Internet can contain viruses. Unless you need to edit, it’s safer to stay in Protected View. Be careful – files from the Internet can contain viruses. If you don’t need to edit, it’s safer to stay in Protected View.
This file was opened from a potentially unsafe location. Click for more details. This file was opened from a potentially unsafe location. Click for more details.
Office has detected a problem with this file. Editing it may harm your computer. Click for more details. Office has detected a problem with this file. Editing them may harm your computer. Click for more details.
This file was opened in Protected View. Click for more details. This file opens in Protected View. Click for more details.
OK, after knowing the important things above, now we will discuss how you can remove Protected View from Microsoft Excel.
Unlock the Microsoft Excel file first
The first way to remove Protected view in Microsoft Excel is to unclock the document or disable the feature using the trust center. Unlocking the file itself is a feature that allows users to edit and also make changes to the document without having to experience any problems with Windows protection.
If, for example, we use unlock, the document will no longer display the Protected view statement as usual. The question is how to unlock Microsoft Excel files? OK, don’t worry because it’s quite easy. In this case, you can right-click on the part of the Excel document that was having problems.
Then you can click on the properties menu. Then just tick the unlock section which is located at the bottom right with the words this file came another computer and might be blocked to help protect This computer. For example, you can click the apply menu there, and that way the unlock feature will disappear.
The last step you need to take is to click OK on the screen. And now you can open the file without having to find the information above. It’s quite easy and short, right?
Disable Protected View via Trust Center
The following way to remove Protected view in Microsoft Excel is to disable protected view using the trust center. This method will prevent the protection from working. So that later the valval that you get from someone else or that you have downloaded from the internet will no longer be protected.
The way you can do this is by first opening the Microsoft Excel program you are using, then you can open any Excel document. Next, just select the options menu. And there you will find various choices. To continue the steps you can select the trust center menu. Then select trust center settings.
Look at the video section and you can remove all the ticks that say enable. Starting from enabling Protected view for Files originating from the internet, then enabling Protected view for files located in potentially unsave locations, and others. If so, just click OK. Then remove Protected view.
So, it’s relatively easy and fast, right? So those are some ways you can try to overcome the problem of enabling editing text appearing. In fact, this is a statement that shows that, for example, the document is protected by Microsoft. But if, for example, you feel disturbed by the writing, it’s better to just disable it.
Today so that later you can immediately edit documents or view them without having to bother removing the enable information which can be said to be a bit annoying. OK, that’s the discussion this time, hopefully it’s useful and good luck.