Guides
Excel File Opens as Read-Only? Every Cause and How to Turn It Off
Updated 2026-10-18
The file opens but you can't change it: the title bar says Read-Only, a yellow bar sits at the top, or saving only offers Save As. "Read-only" has several unrelated causes; go through them in this order.
1. Protected View (yellow bar: Enable Editing)
Files downloaded from the internet or opened from email attachments open in Protected View, with a yellow bar saying so.
- Click Enable Editing on the bar.
- If it happens every time for a file you trust, right-click the file → Properties, tick Unblock at the bottom of the General tab, OK.
2. Marked as Final (yellow bar: Marked as Final)
The author used File → Info → Protect Workbook → Mark as Final, and the bar says the author has marked the workbook as final.
- Click Edit Anyway on the bar.
- To remove it for good: File → Info → Protect Workbook and click Mark as Final again.
It's a notice, not protection; anyone can turn it off.
3. Read-only recommended (a prompt when opening)
A prompt asks whether to open as read-only unless you need to save changes. Click No and edit normally.
To stop the prompt: File → Save As → Browse, then in the dialog Tools → General Options, untick Read-only recommended and save.
4. The file itself is read-only
Right-click the file → Properties: if Read-only is ticked on the General tab, Excel can only open it read-only. Untick it. Files opened straight from a disc, some cloud folders or a zip are read-only too; copy them to a local folder first.
5. Someone or something else has it open
Excel says the file is locked for editing by another user. Possibly:
- a colleague has it open on a shared drive;
- a leftover Excel process of your own is still running in the background (end it in Task Manager and reopen);
- a sync client is syncing it.
Close it on the other side, or save a copy and edit that.
6. Not read-only: the sheet or workbook is protected
You can save, but cells won't change and Excel says the cell or chart you're trying to change is on a protected sheet, or you can't add, delete or rename sheets. That's sheet protection or workbook structure protection.
Remove the flags stored in the file at once
xlszip's Unprotect tool removes the restrictions written into the file in one go:
- sheet protection, workbook structure protection and allow-edit ranges;
- read-only recommended;
- Mark as Final.
Values, formulas and formatting stay the same, and a single file up to 10 MB is processed in your browser by default without uploading. Protected View, the read-only attribute and file locks live on your computer, not in the file, so handle those as described above. An open password is real encryption and is not cracked.