Turn off Protected View in Excel to improve performance of opening Excel documents.
Overview
Turn off Protected View in Excel to improve performance of opening Excel documents.
Overview
Excel's Protected View feature opens documents in read-only mode, and disables editing functions. There are several reasons why documents are opened in read-only mode. Documents opened from the SmartVault Drive are considered "Files originating from the internet" and are opened in Protected Mode by default.
Excel's Protected View feature opens documents in read-only mode, and disables editing functions. There are several reasons why documents are opened in read-only mode. Documents opened from the SmartVault Drive are considered "Files originating from the internet" and are opened in Protected Mode by default.
Cause
This feature however, slows down the opening of excel documents . To turning off protected mode for Files originating from the internet will increase the speed of which excel files open from the Outlook etc...
Resolution
This feature however, slows down the opening of excel documents . To turning off protected mode for Files originating from the internet will increase the speed of which excel files open from the Outlook etc...
Resolution
To disable Protected View in Excel, follow the steps in this section. These steps can be applied for Excel 2010, 2013 and 2016.
-
Click File > Options.
-
Click Trust Center > Trust Center Settings > Protected View.
-
Uncheck Enable Protected View for files originating from the internet.
Example Snap Shot from Excel 2010
To disable Protected View in Excel, follow the steps in this section. These steps can be applied for Excel 2010, 2013 and 2016.
- Click File > Options.
- Click Trust Center > Trust Center Settings > Protected View.
- Uncheck Enable Protected View for files originating from the internet.
Example Snap Shot from Excel 2010
EmoticonEmoticon