Whenever you download a Microsoft Excel file from the internet, receive one as an email attachment, or open a file stored on a shared network drive, Excel will launch it in “Protected View.” You will see a large, bright yellow banner across the top of your screen warning you about potential viruses, and you will be completely unable to type data, edit formulas, or run macros until you click the “Enable Editing” button.
Microsoft designed this feature to stop malicious macros from automatically executing the moment you open a seemingly harmless spreadsheet. However, if your entire job revolves around downloading hundreds of internal company reports from your own trusted corporate intranet or a secure CRM system, clicking “Enable Editing” 50 times a day is a massive waste of time. If you only ever open trusted files and are confident in your antivirus software, you can disable Protected View entirely.
Disabling Protected View via the Trust Center
You can turn off these protective barriers by diving deep into Excel’s advanced security settings, known as the Trust Center.
- Open the Microsoft Excel desktop application.
- Look at the main menu ribbon at the top of the screen and click on File (in the top-left corner).
- Scroll all the way down the blue sidebar on the left and click on Options (usually the very last item).
- A new “Excel Options” window will appear. In the left-hand menu of this window, scroll down and click on Trust Center.
- In the main panel, click the large button labelled Trust Center Settings….
- A secondary window will open. In the left-hand menu of this new window, click on Protected View.
- You will see three distinct checkboxes:
- 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 eliminate the yellow banner, click all three checkboxes to uncheck them.
- Click the OK button to close the Trust Center, and then click OK again to close the main Options menu.
The change is instantaneous. The next time you download a spreadsheet from your email or web browser and double-click it, Excel will open the file instantly in full editing mode, completely skipping the yellow warning banner.