excel cannot open file in protected view

(Excel provides a set of default trust locations.) If there is no trusted local folder location listed, select Add new location, and add the location in the Trusted Location dialog box.

Save the HTML file to a trusted location on the local computer.

To do this, select File > Options > Trust Center > Trust Center Settings > Trusted Locations. To use the existing Trusted Locations capabilities of Excel 2016, Excel 2013, and Excel 2010, follow these steps:

Right-click the file, and then select Properties.

To unblock access for individual files that you know are safe, follow these steps: To open files directly without using Protected View, use one of the following methods. If you trust the source of the workbook, you can then enable editing. More Information Protected ViewĪfter you install the latest Office update, Excel will open workbooks in Protected View to provide an additional layer of security. These services provide files that are updated automatically, based on the Windows Update settings for the computer. These updates will also be published to Windows Update and Windows Server Update Services (WSUS) in mid-August. See the following Microsoft Knowledge Base article for your version of Office to download the update from the Microsoft Download Center: Overview of the update process for Microsoft 365 Apps for enterprise Windows Installer version (MSI)

Install the latest updates (this includes Current Channel, First Release Deferred Channel, and Deferred Channel).įor more information about how to obtain the latest Office updates, see the following TechNet topic:

Microsoft 365 subscription (Click-to-Run) To resolve this issue, install the latest update for your version of Microsoft Office. There is no warning or other indication that the file was not opened. After the security updates are installed, Excel no longer opens the workbook because these files are incompatible with Protected View. Previously, when you tried to open an HTML or XLA/XLAM file from an untrusted location, Excel opened the workbook without using Protected View security. This change is included in the July 2016 security updates (MS16-088). The Microsoft Excel team has made a change in the behavior of certain file types to increase security.

Excel cannot open file in protected view