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:

(Recommended)
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.

Share and Enjoy:
  • Print
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Twitter
  • Google Bookmarks
  • LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *