Protected View Editing this file is not allowed
|
See all How-To Articles This tutorial will demonstrate how to turn off Protected View and Enable Editing in Excel. Files opened from potentially unsafe locations are opened in Protected View. Protected View is a read-only view where most editing functions are disabled until the user enables editing. 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 ModeOnce 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. OR 2. In the Ribbon, click File > Info > Enable Editing. Changing Protected View SettingsTo 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. Why I cant edit the Excel in Protected View?Disabling Protected View to Edit Excel Files
Go to File > Options. Select Trust Center > Trust Center Settings > Protected View. Clear the box for Enable Protected View for files originating from the internet.
What does it mean when a file can't open in Protected View?Excel Protected View is a mode that allows users to open files while disabling most editing features. If you cannot open an Excel file in Protected View, there's reasonable evidence to indicate the file is coming from an unsafe location. Or that it could be malware-ridden.
When I open Excel It says file type not supported in Protected View?From the Options dialog box, go to Trust Center and click on Trust Center Settings. From the Trust Center Settings dialog box, select the Protected View tab. Uncheck the appropriate option under the Protected View section, and then click OK to apply the changes.
|
