Excel File Read-Only and Won't Let You Edit? Here's Every Fix (2026)
Excel uses the word “Read-Only” for six completely different situations — and each one needs a different fix. Clicking “Enable Editing” works for one case. Deleting a hidden lock file works for another. A password-removal tool is needed for a third. This guide tells you which situation you're in and exactly what to do.
Published August 2026 · SimpleTool Team
Quick diagnosis
Look at the top of your Excel window right now:
Protected View
What you see
“Yellow bar at the top: "PROTECTED VIEW — Be careful — files from the internet can contain viruses."”
Why this happens
Excel's security sandbox. Any file opened from email, a download folder, a ZIP archive, or a cloud sync triggers this automatically — it is not a sign the file is corrupted or malicious.
How to fix it
Click the "Enable Editing" button in the yellow bar. The file immediately becomes editable. No password, no tool required.
Marked as Final
What you see
“Yellow bar: "MARKED AS FINAL — An author has marked this workbook as final to discourage editing."”
Why this happens
The author used File → Info → Protect Workbook → Mark as Final before sharing. It is a courtesy signal, not real protection — anyone can remove it.
How to fix it
Click "Edit Anyway" in the yellow bar. Or go to File → Info → Protect Workbook → Mark as Final to toggle it off.
Sheet protection
What you see
“Cells turn grey when you click them. A padlock icon appears in the status bar. You may see: "The cell or chart you're trying to change is on a protected sheet."”
Why this happens
The worksheet has a protection flag applied — it restricts cell editing, formatting, inserting rows, and similar actions. It is stored as an XML attribute in the file, not encryption.
How to fix it
Go to Review → Unprotect Sheet. If a password is requested and you don't know it, a browser-based tool can remove the protection flag directly from the file without the password.
No password? Remove the protection flag directly from the .xlsx file — no password needed.
Remove sheet protection →Workbook structure protection
What you see
“You cannot right-click sheet tabs to add, rename, or delete sheets. The "Insert Sheet" button is greyed out. Review → Protect Workbook appears highlighted.”
Why this happens
The workbook structure has a protection flag — it locks the sheet architecture while leaving cell editing free. Also stored as an XML attribute, not encryption.
How to fix it
Go to Review → Protect Workbook and click again to toggle it off. If a password is required and you don't have it, a browser-based tool can strip the flag from the file.
No password? Remove the protection flag directly from the .xlsx file — no password needed.
Remove workbook protection →File-level encryption (open-on-launch password)
What you see
“A password prompt appears before the file opens at all. Without the correct password, Excel shows "The password you supplied is not correct."”
Why this happens
The file is encrypted with AES-128 or AES-256 at the container level (CFBE format). This is fundamentally different from sheet or workbook protection — the entire file content is ciphertext.
Honest answer
There is no free or browser-based way to bypass file-level encryption. You need the original password. Contact the person who created or sent the file and request the password or an unprotected copy.
Windows read-only file attribute
What you see
“No Excel warning bars. The title bar shows "[Read-Only]". Right-clicking the file in Explorer → Properties shows "Read-only" is checked.”
Why this happens
The file itself has the Windows read-only attribute set — often because it was copied from a CD, a read-only network share, or extracted from a ZIP without preserving write permissions.
How to fix it
Right-click the file in File Explorer → Properties → uncheck "Read-only" → OK. Alternatively, in PowerShell: Set-ItemProperty -Path "file.xlsx" -Name IsReadOnly -Value $false
Summary: 3-step process
Identify which read-only message Excel is showing
Look at the top of the Excel window. A yellow bar with "Protected View", "Marked as Final", or a "PROTECTED" label tells you the exact cause. No yellow bar? Check whether cells are greyed out (sheet protection) or sheet tabs are locked (workbook protection), or whether the title bar says "[Read-Only]" (Windows file attribute).
Apply the matching fix
Protected View: click "Enable Editing". Marked as Final: click "Edit Anyway". Sheet or workbook protection without a password: use the browser-based removal tool. File locked by another user: clear the stale lock file. Windows read-only attribute: uncheck it in file Properties.
For sheet or workbook protection without the password
Go to simpletool.co/unlock-excel. Drop the .xlsx or .xlsm file. Sheet protection, workbook protection, and protected ranges are removed automatically in your browser — no upload, no password required. Download the unprotected file.
Which types can be removed without the password?
| Lock type | Password required? | How |
|---|---|---|
| Protected View | No password | Click Enable Editing |
| Marked as Final | No password | Click Edit Anyway or toggle in File menu |
| Sheet protection | Not required | Browser-based removal tool (or Review → Unprotect if you know it) |
| Workbook structure protection | Not required | Browser-based removal tool (or Review → Protect Workbook if you know it) |
| File-level encryption | Required — no bypass | Only the original password works |
| Shared-file lock | No password | Close all sessions / delete stale lock file |
| Windows read-only attribute | No password | Uncheck in file Properties |
Frequently asked questions
Why does my Excel file open as read-only even though I own it?
The most common cause is Protected View — a security feature that opens any file downloaded from the internet, attached to an email, or received via a cloud sync in a sandboxed read-only mode. Click the yellow "Enable Editing" bar at the top of the screen. If that bar is not there, the read-only state has a different cause: check whether the file has sheet protection, workbook protection, or a Windows read-only file attribute.
How do I remove the "Protected View" message in Excel?
Click the yellow bar at the top that says "PROTECTED VIEW — Be careful — files from the internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View." Click "Enable Editing" on the right side of that bar. Excel immediately exits Protected View and allows editing. If you trust the source and receive many such files, you can adjust Protected View settings under File → Options → Trust Center → Trust Center Settings → Protected View, but be aware this reduces security.
What is the difference between sheet protection and workbook protection?
Sheet protection locks individual worksheets — it prevents editing cells, formatting, inserting rows, and similar actions within a specific tab. Workbook protection locks the workbook structure — it prevents adding, deleting, renaming, or moving sheets. A file can have both applied simultaneously. Both are stored as flags in the file structure (not encryption) and can be removed with the right tool.
Excel says the file is "locked for editing by another user" — what do I do?
This occurs with files stored on a network drive or SharePoint when another user (or a crashed session) holds the file lock. First, confirm no one else has the file open. If the file is on a network share, the lock file (a hidden file starting with ~$ in the same folder) can be deleted when no other user actually has it open. For SharePoint, wait a few minutes for the lock to release, or contact your SharePoint admin. As a last resort, request the other user closes the file, or open a copy.
Can I remove Excel protection without the password?
Yes — for sheet protection and workbook structure protection. Excel stores these as flags inside the file structure, not as encryption. The original password is not required to remove them. This is different from file-level encryption (the password that appears before the file opens), which uses AES encryption and cannot be bypassed without the original password.
The "Enable Editing" button is greyed out or missing — what does that mean?
If the Enable Editing button is missing, Protected View is not the cause. Look for other indicators: a "PROTECTED" or "MARKED AS FINAL" message bar, the Review tab showing "Protect Sheet" or "Protect Workbook" as active, or the file being opened from a SharePoint location in read-only mode. Each of these is a different lock type with a different fix — the relevant section above covers each one.
I tried everything — the file still won't let me edit
If you have tried all six fixes and the file still opens read-only, it is most likely file-level encrypted (a password is required before the file opens) and you do not have the password. In this situation, there is no browser-based or free solution — the file cannot be unlocked without the original password. Contact the person who sent or protected the file and request the password or an unprotected copy.
Remove Excel sheet or workbook protection
No password required. Drops the protection flag from the .xlsx file directly in your browser — no upload.
Open Excel Password Unlocker →