Whenever you download an Excel spreadsheet from the internet, open an attachment from your email, or access a file from a shared network drive, Microsoft Excel will likely open the document in “Protected View”. This security feature locks the spreadsheet and displays a prominent yellow warning banner across the top of the screen, forcing you to click “Enable Editing” before you can actually type anything or run macros.
Protected View is designed to prevent malicious code from executing on your computer automatically. However, if you work in an environment where you constantly download internal reports from a trusted company intranet, this repetitive extra click becomes a significant annoyance. If you trust the sources of your files, you can completely disable this warning banner in the settings.
Disabling Protected View in the Trust Center
Because Protected View is a core security feature, the toggle switches to turn it off are buried deep within Excel’s advanced Trust Center settings.
- Open the Microsoft Excel desktop application. (You can open a blank workbook if necessary).
- Click on the File tab located in the top-left corner of the ribbon menu.
- Look at the very bottom of the green sidebar on the left and click on Options.
- The “Excel Options” window will appear. In the left-hand navigation pane, click on Trust Center.
- In the main panel, click the button labelled Trust Center Settings….
- A new window will open. In the left-hand sidebar of this new window, click on Protected View.
- You will now see three distinct checkboxes that control exactly when the yellow warning banner appears:
- Enable Protected View for files originating from the Internet
- Enable Protected View for files located in potentially unsafe locations
- Enable Protected View for Outlook attachments
- To completely disable the feature, uncheck all three boxes.
- Click the OK button to close the Trust Center, and then click OK again to close the Excel Options window.
The next time you download a spreadsheet or open an email attachment, Excel will bypass the security check and open the file directly into editing mode, exactly as if you had created it yourself.