How to Disable Protected View in Microsoft Excel

How to Disable Protected View in Microsoft Excel

You may find that the numbers displayed in your Volatility Backup XLS do not match the numbers in Corporate Focus. This mis-display of numbers is due to the “Protected View” setting within Microsoft Excel. All Microsoft Office files downloaded from the Internet (and Corporate Focus) are “blocked” by default.
There are several ways to get around this issue:
The simplest and most secure method to get around this issue is to simply click the Enable Editing button, on a per-document basis, when you open an Excel (or other Microsoft office) file that has been downloaded.
(NOT Recommended)
Alternatively, you can choose to disable the Protected View feature within Excel so that you no longer recieve the warning upon opening any Excel file that has been downloaded. In Excel go to File > Options > Trust Center > Trust Center Settings > Protected View, and then uncheck Enabled Protected View for files originating from the Internet.
There is also, in Trust Center Settings, a Macro Setting that you can use to Enable All Macros by default. Be aware that enabling this feature allows potentially dangerous code to run.
If either of these Trust Center settings are changed, you need to be very careful about the Excel files that get opened.
Protected View can stop viruses from installing onto your computer but comes at the price of clicking a button every time you want to edit a document. Here’s how to permanently disable Protected View for all documents in Microsoft Office.
Microsoft added many usability and security features to Office 2010 that help protect end users from embedded plugins and viruses that can crash Office or even install viruses. These features go a long way to keep your computer running smoothly, but there are still options you can tweak to disable Protected View for specific files. To fine tune your Protected View options have a look below.
Disable Protected View for Specific Documents
To get to the protected view options, open Microsoft Word 2010 and then go to file and options.

On the left column click Trust Center and then click Trust Center Settings.

Now on the left column click Protected View and uncheck any documents you would like to open automatically with Protected View disabled. This will allow you to edit the documents without needing to enable editing but may also make your computer an easy target for zero day virus exploits.

Once you check or un-check the settings you want you can close the windows. Repeat these steps for Microsoft Excel and Powerpoint if you want to disable Protected View there too.
Modify Safe Locations
To add more locations that are marked as safe for Protected View go back to the Trust Center Settings and click Trusted locations on the left.

Click add new locations at the bottom and browse to the location you would like to add to the trusted locations list.

Any documents in the new location will now be marked as safe.
Disable Protected View from Registry
Like most options in Windows there is a way to disable these settings via the registry too. If for some reason the options in Office do not work or you want to be able to automate this setting for multiple computers you can try setting one or more of these registry values below.




The three values you would want to set are:
By setting each value to 1 you will disable Protected View for that file location.

Read More: