This tutorial will demonstrate how to turn off Protected View and Enable Editing in Excel.
Files that are being opened from locations that are not considered safe by your computer may end up being opened in Protected View. Protected View is a read-only view where most editing functions are disabled until the user enables editing in the file.
Why Does My File Open in Protected View?
Files that are downloaded from the Internet are usually opened in Protected View, because these files can contain malware or viruses. If you’re confident that the file is safe to edit, click Enable Editing in the message bar that appears.
Files that are sent as Outlook attachments are also usually opened in Protected View.
Files that are opened from an unsafe location will also display a Protected View message. An unsafe location can be the Temporary Internet Files folder, for example.
Files that you choose to open in Protected View will also show a message.
You can open a file in Protected View by selecting File > Open > Open in Protected View.
Enabling Edit Mode
Once you’re confident that the file will not damage your computer, you can enable editing in one of two ways.
1. Click on Enable Editing in the message box that pops up.
2. In the Ribbon, click File > Info > Enable Editing.
Changing Protected View Settings
To switch off Protected View, change the settings in the Excel Trust Center.
1. In the Ribbon, select File > Options > Trust Center.
2. Select Trust Center Settings, and then select Protected View.
3. Remove the check marks from the three check boxes in Protected View.
4. Click OK to save the changes.
Protected View messages will now no longer be displayed in Excel.