To remove read-only from an Excel file, start with the message at the top of the workbook. If you see a yellow bar, select Enable Editing (Protected View) or Edit Anyway (Marked as Final). If Excel asks whether to open the file as read-only, the owner turned on Read-only recommended; to turn it off, save the file with File > Save As > More options > Tools > General Options and clear the check box.
A file can also be read-only because of Windows file properties, a locked cloud or network copy, or another person having it open. The table below matches each symptom to its fix.
Quick Answer
Select Enable Editing or Edit Anyway if you see a yellow bar. Otherwise, clear Read-only recommended in Save As > Tools > General Options, or clear Read-only in the file’s Properties.
Find the Cause
| What you see | Cause | Fix |
|---|---|---|
| Yellow bar: PROTECTED VIEW | File came from the internet or email | Select Enable Editing |
| Bar: MARKED AS FINAL | Author marked it final | Select Edit Anyway |
| Prompt to open as read-only | Read-only recommended is on | Clear it in General Options |
| “[Read-Only]” in the title bar | Windows file attribute or folder permissions | Clear Read-only in Properties |
| “Locked for editing by…” | Someone else has it open | Ask them to close it, or open a copy |
| Cells won’t change but the file saves | Sheet or workbook protection | Review > Unprotect Sheet |
Turn Off “Read-only recommended”
- Open the file (choose No when asked to open read-only).
- Select File > Save As, then Browse (or More options).
- In the Save As window, select Tools > General Options next to the Save button.
- Clear Read-only recommended. If there’s a Password to modify you know, delete it too.
- Select OK, then Save and replace the file.
Clear the Windows Read-Only Attribute
- Close the file in Excel.
- Right-click it in File Explorer and choose Properties.
- On the General tab, clear Read-only and select OK.
If the check box turns back on, you may not have permission to change the folder. Here’s how to unlock a locked file in Windows.
Unprotect a Sheet or Workbook
- Select Review > Unprotect Sheet (or Protect Workbook to turn off workbook protection).
- Enter the password if one was set.
If you don’t know the password, ask the person who set it. Excel doesn’t provide a way to recover it.
Troubleshooting
- Protected View every time: For files you trust, save a copy to a trusted location, or add the folder in File > Options > Trust Center > Trust Center Settings > Trusted Locations.
- OneDrive or SharePoint files open read-only: Check that you have edit permission, and that sync isn’t paused. Open in the desktop app from the web if needed.
- “Locked for editing” by you: A previous Excel session crashed. Restart the PC to release the lock, or delete the hidden ~$ temporary file next to the workbook.
Frequently Asked Questions
Why is my Excel file stuck in read-only?
Usually because of Protected View, Read-only recommended, the Windows read-only attribute, or another user having it open.
Can I edit a read-only file without changing it?
Yes. Use File > Save As to save a copy under a new name, then edit the copy.
Summary
- Select Enable Editing or Edit Anyway on yellow bars.
- Clear Read-only recommended in General Options.
- Clear Read-only in the file’s Properties.
- Unprotect sheets with Review > Unprotect Sheet.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.