Excel Protected View: why you can't edit and how to fix it

What Protected View is and why your file is in it

Protected View is a read-only sandbox Excel uses for files that might be unsafe. You can read, scroll and copy, but not type, and macros and external links don't run. Windows marks files that come from the internet, and Excel checks that mark and where the file is when it opens it.

There are three yellow-bar triggers. The file came from the internet (a download or a file sent through some chat apps). It's an Outlook attachment opened from the message. Or it's in a location Excel treats as unsafe, such as the temporary internet files folder. The table above shows each message and the red-bar variants.

1. Yellow bar: Enable Editing

If you know who sent the file and expected it, click Enable Editing. Excel reopens it normally, and AutoSave and editing work again. For an attachment, it's often better to save it to a folder first (in Outlook, right-click the attachment and choose Save As) and open it from there, so your changes don't go into a temporary copy you can't find later.

If you didn't expect the file, don't enable editing. Reading it in Protected View is safe; that's the point of it. Check with the sender through another channel if a file asks you to enable editing or macros to "see the content".

2. The same file keeps opening in Protected View: Unblock it

A downloaded file keeps its "came from the internet" mark until you remove it. Doing this also matters for macro workbooks: Excel blocks macros in files with that mark and shows a red Security Risk bar saying Microsoft has blocked macros because the source is untrusted. Unblock only files you trust.

1. Close the file in Excel.
2. In File Explorer, right-click the file and choose Properties.
3. On the General tab, at the bottom next to Security, tick Unblock. If there's no Unblock box, the file isn't marked.
4. Click OK and open the file again.

3. Red bar: Office has detected a problem with this file

This means the file failed Office's file check: it may be damaged, made by a program that writes non-standard files, or deliberately malformed. Click the message to see the details on the File > Info page. Excel may offer Edit Anyway; only use it for a file you trust, from a source you can confirm.

The safer fix is a fresh copy: ask the sender to save it again as .xlsx and resend it, or export it again from the system it came from. If the file won't open at all, the Excel cannot open the file guide covers damaged and mislabelled files.

4. Turning it off, and the safer option: a trusted folder

The switches are in File > Options > Trust Center > Trust Center Settings > Protected View. There are three ticks: files originating from the internet, files in potentially unsafe locations, and Outlook attachments. Leave all three on. Turning them off removes a real layer of protection against malicious files, and on a work PC your IT team may have locked them anyway.

If you regularly open the same safe exports, use a Trusted Location instead: Trust Center Settings > Trusted Locations > Add new location, and choose one folder you control, such as Documents\Reports. Files saved there open without Protected View. Be aware that trusted locations also let macros run without asking, so never add Downloads, your desktop or a whole drive.

Enable Editing worked but you still can't change cells

Then something else is stopping you. "The cell or chart you're trying to change is on a protected sheet" means sheet protection: use Review > Unprotect Sheet, with the password if one was set. A Restricted Access bar or a sensitivity label means the owner limited who can edit; ask them for permission. And a [Read-Only] title with no bar has the causes in the remove read-only guide.