How to Disable Read Only in Excel: A Complete Guide

If you've ever opened an Excel file only to find you can't edit it, you've run into Read Only mode. It's one of the more frustrating friction points in everyday spreadsheet work — but the fix isn't always the same. Where Read Only comes from determines how you remove it, and Excel can trigger it in several different ways.

What Does Read Only Mean in Excel?

Read Only in Excel means the file is open for viewing but not for editing. Any changes you make either can't be saved to the original file or are blocked entirely. It sounds simple, but the cause matters because there are at least five distinct sources of Read Only status — and each requires a different approach.

Understanding the source is step one.

The Five Sources of Read Only in Excel

1. The File Has a Read Only Recommendation

Excel allows authors to save files with a Read Only recommendation. When you open the file, a dialog box asks whether you want to open it as read only. If you click "Yes" (or accidentally do), the file opens in that mode.

Fix: Close and reopen the file. When the prompt appears, click No to open it in editable mode. This doesn't change the file itself — it just changes how you opened it this session.

2. The File Property Is Set to Read Only

At the operating system level, the file itself may have its read-only attribute enabled. This is common with files copied from USB drives, downloaded from the internet, or shared via certain sync tools.

Fix on Windows:

• Right-click the file in File Explorer
• Select Properties
• Under the General tab, look for the Read-only checkbox in the Attributes section
• Uncheck it, then click Apply

Fix on Mac:

• Right-click (or Control-click) the file in Finder
• Select Get Info
• Under Sharing & Permissions, check that your user has Read & Write access

3. Protected View Is Active

Excel opens files in Protected View automatically when they come from potentially risky sources — email attachments, downloads, or locations Excel considers unsafe. A yellow bar appears at the top of the screen.

Protected View is a security feature, not a file attribute. The file itself isn't read only — Excel is choosing to restrict editing as a precaution.

Fix: Click Enable Editing in the yellow notification bar. For files you download regularly from trusted sources, you can also adjust Trust Center settings under File → Options → Trust Center → Trust Center Settings → Protected View.

⚠️ Only disable Protected View for sources you genuinely trust. It exists for a reason.

4. The Workbook or Sheet Is Password-Protected

Excel allows authors to protect workbooks and individual worksheets with passwords. This prevents editing of specific cells, structure changes, or both. The protection can be at the sheet level (can't edit cells) or the workbook level (can't add/delete/rename sheets).

Fix:

• For sheet protection: Go to Review → Unprotect Sheet. If a password was set, you'll need to enter it.
• For workbook structure protection: Go to Review → Protect Workbook and toggle it off (password may be required).

If you don't know the password and you own the file, recovery options are limited — Excel's protection is designed to be difficult to bypass without the original password.

5. The File Is Shared or Locked by Another User 🔒

In shared environments — including OneDrive, SharePoint, or a network drive — a file may appear as read only because another user has it open and has the editing lock. Excel displays a notification indicating who has the file open.

Fix:

• Wait for the other user to close the file
• Or use Edit Anyway if your version and sharing settings allow it (this creates a conflict copy that needs to be merged)
• In Microsoft 365 with co-authoring enabled, multiple users can edit simultaneously without this issue

Quick Reference: Read Only Sources and Fixes

Factors That Affect Which Fix Applies to You

The right solution depends on several variables specific to your situation:

• Where the file came from — downloaded, emailed, copied from external media, or created locally
• Your version of Excel — Microsoft 365, Excel 2021, 2019, 2016, or the web version each have slightly different menu locations and available features
• Your permissions — on shared drives or SharePoint, your access level is set by an administrator, not by Excel itself
• Whether you set the protection yourself — if someone else protected the file, you need their password or their cooperation
• Your OS — file attribute settings differ between Windows and macOS, and the Excel web app behaves differently from the desktop versions

Excel's co-authoring feature in Microsoft 365 has largely eliminated the "locked by another user" problem for cloud-based files, but only when the file is stored in OneDrive or SharePoint — not on a local network drive.

When the Fix Isn't Straightforward

Some situations are genuinely complex. If a file is protected with a password you don't have, or if it's stored on a SharePoint site where your permissions are restricted, removing Read Only status isn't just a setting you can change — it requires access you may not have.

Similarly, files received from external sources sometimes have multiple layers of protection: the OS-level attribute, Protected View, and sheet protection all active at once. In those cases, you'll need to work through each layer independently.

The method that works for you depends entirely on which combination of these factors applies to your file, your version of Excel, and your access rights — and that's a picture only your specific setup can complete.