Repeat these steps for Microsoft Excel and Powerpoint if you want to disable Protected View there too. Once you check or un-check the settings you want you can close the windows. 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. Now on the left column click Protected View and uncheck any documents you would like to open automatically with Protected View disabled. On the left column click Trust Center and then click Trust Center Settings. To get to the protected view options, open Microsoft Word 2010 and then go to file and options. To fine tune your Protected View options have a look below.ĭisable Protected View for Specific Documents 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.
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.
Here’s how to permanently disable Protected View for all documents in Microsoft Office. 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. If either of these Trust Center settings are changed, you need to be very careful about the Excel files that get opened.
Be aware that enabling this feature allows potentially dangerous code to run. There is also, in Trust Center Settings, a Macro Setting that you can use to Enable All Macros by default.
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. 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.Īlternatively, 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. There are several ways to get around this issue: All Microsoft Office files downloaded from the Internet (and Corporate Focus) are “blocked” by default. This mis-display of numbers is due to the “Protected View” setting within Microsoft Excel. You may find that the numbers displayed in your Volatility Backup XLS do not match the numbers in Corporate Focus. Access VBA change Query criteria using QueryDef.How to Disable Protected View in Microsoft Excel.Access replace Crosstab Query with Expression.Solution to Access Error 3047 Record is too large.Microsoft Access produce Cartesian product with Cross Join.MS Project delete Summary Task without deleting subtasks.Access VBA import txt using DoCmd.TransferText Method.Access VBA delete Table using DoCmd.DeleteObject Method.Access VBA loop through all Tables using DAO.TableDef.Access VBA run Query or run Action Query.Access VBA import workbook to Access using Transferspreadsheet.Access StrComp Function to Compare text (case sensitive comparison).Access Case Sensitive Join Table (Inner Join, Left Join).Access VBA delete Table records with SQL using DoCMD.RunSQL Method.MS Access select the first record of each group using First Function.Report this ad Categories Categories Archives Archives report this ad Recent Posts You can do the same for other Microsoft Office applications such as Microsoft Word.
To disable the feature, check all the box To enable the feature, uncheck all the box To disable the Protected View feature permanently, navigate toįILE tab > Options > Trust Center >Trust Center Setting > Protected View At the time you open the Excel workbook, the application horizontal / vertical scroll bars are gone, the worksheet tabs are also gone, you have to re-enable them in the Options.Īfter you click on Enable Editing button, depending on your file size, this will take a long time to load the workbook and sometimes cause the workbook to freeze. Protected View can be an extremely annoying feature. Message may vary depending on the situation.Įnable and Disable Protected View in Excel When the Protected View feature is enabled before the unsafe workbook is opened, the following message appears. Protected View is a feature that you can enable or disable in Option. The protection is achieved by disabling some features and making the Workbook read only. Protected View feature is used to protect your computer from virus when you try to open Excel workbook from the Internet or other unsafe locations, or open attachment in Outlook email. This Excel tutorial explains how to enable and disable Protected View in Excel and other Office applications.