Protected View stops Excel from running macros and external data connections until you say it's safe

Protected View is a read-only mode that Excel enters when you open a file from the internet, an email attachment, or an untrusted location. It blocks macros, external data queries, and editing until you explicitly enable the content. If you trust the file and want to work with it normally, you can disable Protected View for that single file, for files from a specific location, or turn it off entirely in Excel settings.

The fastest route is usually to click "Enable Editing" in the yellow banner at the top of the spreadsheet. If that banner does not appear, or if you want to prevent Protected View from triggering for certain folders, you will need to change Excel's trust settings or move the file to a trusted location.

Key Takeaways

  • Protected View appears as a yellow banner at the top of the spreadsheet and blocks editing, macros, and external connections until you click "Enable Editing".
  • Clicking "Enable Editing" once lets you work with that file normally, but Protected View will trigger again the next time you open it from the same untrusted source.
  • You can add a folder to Excel's trusted locations so files stored there never trigger Protected View.
  • Disabling Protected View entirely in Excel settings removes the protection for all files, which is not recommended unless you have another security measure in place.

Enable editing for a single file right now

When you open a file that Excel considers untrusted, a yellow banner appears below the ribbon with the message "Protected View — Enable Editing". Click the "Enable Editing" button on that banner. The file will switch from read-only mode to normal editing mode, and macros or external data connections will run.

This change applies only to your current session. The next time you open the same file from the same location, Protected View will trigger again. If you want to avoid this repeatedly, move the file to a trusted location or add that location to Excel's trust settings.

Add a folder to trusted locations

If you regularly work with files in a specific folder, you can add that folder to Excel's trusted locations. Files stored there will never trigger Protected View. Open Excel and go to File > Options > Trust Center > Trust Center Settings > Trusted Locations.

Click Add New Location. In the dialog, click Browse and select the folder where your files are stored. Check the box for "Subfolders of this location are also trusted" if you want the setting to apply to any subfolders inside it. Click OK twice to save. Any Excel file you open from that folder will skip Protected View.

This approach works well if you have a Downloads folder, a shared network drive, or a project folder where you keep files you have already vetted. It does not require you to disable the protection globally.

Turn off Protected View in Excel settings

If you want to disable Protected View entirely, open Excel and go to File > Options > Trust Center > Trust Center Settings > Protected View. You will see three checkboxes:

  • Enable Protected View for files originating from the Internet
  • Enable Protected View for files in potentially unsafe locations
  • Enable Protected View for Outlook attachments

Uncheck any or all of these boxes to disable Protected View for those file sources. If you uncheck all three, Protected View will not appear for any file, regardless of where it came from. This is the least secure option and is only recommended if you have antivirus software or another security system actively monitoring file behavior.

Understand why Protected View exists

Protected View was introduced because Excel files can contain macros and external data connections that run automatically when the file opens. A malicious actor can embed code in a spreadsheet that steals data, installs malware, or modifies your system. When a file comes from the internet or an email attachment, you have not verified its source, so Excel assumes it is unsafe.

Disabling Protected View removes this safety check. You should only do this if you are certain the file is legitimate — for example, a spreadsheet you downloaded from your company's internal server, or a file sent by a colleague you trust. If you disable it globally, make sure you have another layer of protection, such as antivirus software or a firewall that scans downloads.

Recognize when Protected View is actually blocking you

Protected View does not just prevent editing — it also blocks macros and external data connections. If you open a spreadsheet that should pull data from a database or run a calculation macro, and nothing happens, check for the yellow banner. Even if you can see and edit the cells, the macro or data connection will not work until you click "Enable Editing".

Some files are designed to work only in Protected View disabled mode. If you enable editing and the file still does not behave as expected, the file itself may require macros to be enabled separately. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and select "Enable all macros" if you trust the file.

Move a file instead of disabling protection

If you download a file and want to work with it without Protected View, the safest approach is to move it to a trusted location rather than disabling the protection. Right-click the file, select Properties, and check the box at the bottom labeled "Unblock" if it appears. This tells Windows the file came from a trusted source. Then move the file to a folder you have already added to Excel's trusted locations.

This approach keeps Protected View active for other files while letting you work with this one normally. It is faster than disabling the protection globally and leaves your security settings intact.

Frequently Asked Questions

Why does Protected View keep appearing even after I click Enable Editing?

Protected View is tied to the file's source, not your action. Clicking "Enable Editing" works only for that session. The next time you open the file from the same location, Protected View will appear again. To prevent this, add the folder to trusted locations or move the file to a folder you have already trusted.

Can I disable Protected View for just one file type, like .xlsm files?

No. Protected View settings in Excel apply to all files based on their source (internet, email, untrusted location) or type (macro-enabled files). You cannot create a rule for a single file type. Your options are to enable editing for that file, add its folder to trusted locations, or disable Protected View entirely.

Does unblocking a file in Windows properties prevent Protected View?

Unblocking a file in Windows properties removes the "downloaded from the internet" flag, which may prevent Protected View from triggering. However, if the file is stored in a location Excel considers unsafe, Protected View may still appear. Adding the folder to Excel's trusted locations is more reliable.

What happens to macros if I disable Protected View?

Disabling Protected View allows macros to run, but only if macro security is also set to allow them. Protected View and macro security are separate settings. You may need to enable macros separately in Trust Center Settings > Macro Settings even after disabling Protected View.

Is it safe to disable Protected View on my work computer?

That depends on your organization's security policy. Many companies require Protected View to remain enabled. Check with your IT department before changing these settings. If your company has antivirus software or email filtering in place, disabling Protected View may be acceptable, but you should get approval first.