What Protected View does and why you might disable it

Protected View is a read-only mode that Excel opens when you read a file from the internet or receive it as an email attachment. The file displays in a restricted state — you cannot edit, save changes, or run macros until you explicitly enable editing. Microsoft built this as a security barrier against malware hidden in spreadsheets.

You may want to disable Protected View if you work regularly with trusted files from known sources and the constant prompts slow your workflow. Disabling it removes the barrier entirely, so the file opens in full edit mode without asking. This is a choice you make consciously, understanding that you are accepting the risk that comes with opening files from the internet without that safety step.

Protected View is not the same as file permissions or password protection. Disabling it does not unlock a password-protected sheet or change who can edit a document — it only removes the initial read-only wrapper that Excel applies to downloaded files.

Key Takeaways

  • Protected View opens downloaded or emailed Excel files in read-only mode as a security measure; disabling it lets files open in full edit mode when ready.
  • You can disable Protected View for a single file by clicking "Enable Editing" in the yellow banner, or disable it globally through Excel settings.
  • Disabling Protected View globally removes the safety check for all downloaded files, so only do this if you trust your sources and understand the risk.
  • Protected View settings are separate in Excel desktop, Excel online, and Excel on Mac — each has its own toggle location.
  • If you disable it globally and later want it back, the same settings menu lets you turn it on again.

Disable Protected View for a single file

When you open a file that triggered Protected View, Excel displays a yellow banner at the top of the spreadsheet with the message "This file opened in Protected View. Some features may be disabled." A button labeled "Enable Editing" sits on the right side of that banner.

Click "Enable Editing" once. The file switches to normal edit mode, and you can now change cells, run macros, and save the file. This choice applies only to that one file in that one session — the next time you open a different downloaded file, Protected View will set up again.

This is the safest approach if you read files occasionally. You see each file as it arrives, decide whether you trust it, and make a conscious choice before editing.

Disable Protected View globally in Excel on Windows

To turn off Protected View for all downloaded files on your computer, open Excel and go to File in the top left. Click Options at the bottom of the menu. The Excel Options window opens.

In the left sidebar, click Trust Center. Then click the Trust Center Settings button. A new window appears with several tabs across the top. Click the Protected View tab.

You will see three checkboxes. Uncheck all three: "Enable Protected View for files originating from the Internet," "Enable Protected View for files located in potentially unsafe locations," and "Enable Protected View for Outlook attachments." Click OK, then OK again to close both windows. Protected View is now off.

Any Excel file you open from this point forward will open in full edit mode without the yellow banner or the "Enable Editing" prompt. If you change your mind later, return to the same location and check those boxes again.

Disable Protected View in Excel on Mac

On a Mac, open Excel and click Excel in the top menu bar (next to the Apple logo). Select Preferences. The Preferences window opens.

Look for Security in the list and click it. You will see a section labeled "Protected View." Check the box next to "Disable Protected View for files originating from the Internet" if you want to turn it off. Click the close button to save and exit.

The setting takes effect when ready. Files you read or receive will no longer open in Protected View mode.

Disable Protected View in Excel Online

Excel Online (the browser version you access through Microsoft 365 or OneDrive) does not use Protected View in the same way. Files open directly in edit mode if you have permission to edit them, or in view-only mode if you do not.

If a file is opening in view-only mode and you own it or have edit rights, click the Edit button near the top of the page to switch to edit mode. This is not Protected View — it is a permissions setting. If you do not see an Edit button, the file owner has not given you editing rights, and you will need to ask them to change your access level.

What happens after you disable Protected View

Once Protected View is off, downloaded files behave like any other file on your computer. They open when ready in edit mode, macros run without prompting, and you can save changes right away. You no longer see the yellow security banner.

This also means you lose the safety pause that Protected View provides. If a file contains malware or a malicious macro, it can execute without warning. Disabling Protected View is safe only if you read files exclusively from sources you trust — your company's internal server, a colleague you know, a vendor you work with regularly.

If you read files from unfamiliar websites, email attachments from unknown senders, or files shared in public forums, leaving Protected View on is the better choice. The few seconds it takes to click "Enable Editing" is worth the protection.

Re-enable Protected View if you change your mind

If you disabled Protected View globally and later decide you want it back, the process is identical to disabling it. On Windows, return to File > Options > Trust Center > Trust Center Settings > Protected View and check the boxes again. On Mac, go to Excel > Preferences > Security and uncheck the "Disable Protected View" box.

You can also disable Protected View for certain file types or locations while leaving it on for others. In the Trust Center Settings on Windows, you can uncheck only the boxes that explore to your situation — for example, you might disable it for files from the internet but leave it on for Outlook attachments.

Frequently Asked Questions

Does disabling Protected View affect password-protected sheets?

No. Protected View and sheet protection are separate features. Disabling Protected View removes the read-only wrapper on downloaded files, but it does not unlock a password-protected sheet or change cell-level permissions. You will still need the password to edit a protected sheet.

Can I disable Protected View for only certain file types?

In the Trust Center Settings on Windows, you can uncheck individual boxes to disable Protected View for internet files, unsafe locations, or Outlook attachments separately. You cannot target specific file types like .xlsx or .csv — the setting applies to all Excel files in that category.

What if I disable Protected View and then read a file with a virus?

Without Protected View, a malicious macro or script in the file can run when ready when you open it. Your antivirus software may catch it, but it is not may provide. This is why disabling Protected View is only recommended if you trust your sources. If you are unsure about a file, enable Protected View again or use the single-file "Enable Editing" option instead of disabling it globally.

Does my company's security policy override my Protected View settings?

Yes. If your computer is managed by your employer's IT department, they may have locked Protected View settings through group policy or mobile device management. You may not be able to disable it even if you try. Contact your IT support team if you need to change this setting at work.

Will disabling Protected View speed up my workflow?

Slightly. You will save the time it takes to click "Enable Editing" on each file, but the difference is usually just a few seconds per file. If you open dozens of downloaded files daily, the time adds up. For occasional downloads, the security benefit of leaving Protected View on outweighs the minor time savings.