How to Edit an Excel Sheet When It Is Read-Only | 6 Fixes That Work

Read-only restrictions in Excel come in six distinct types—the right fix depends on identifying the specific lock holding your sheet hostage.

A read-only Excel file stops you cold. The fix for how to edit an Excel sheet when it is read-only starts with identifying the specific lock type. Most files get stuck because of a yellow warning banner, a simple Windows property setting, a saved password, or a hidden “ghost” lock file. Below are the six scenarios that cause this problem and the step-by-step fix for each.

Why Is My Excel File Read-Only?

Excel goes read-only to protect you from editing a file that is marked as final, downloaded from an untrusted source, or currently open in another session. The software itself isn’t broken—it’s following safety rules. Once you know which rule is activated, the fix takes seconds.

The table below maps the six lock types to their symptoms and immediate solutions.

Editing a Read-Only Excel Sheet: Start With This Step

Before diving into complex fixes, check the yellow banner. This single action resolves roughly half of all read-only issues.

Fix 1: The Yellow Banner (Protected View or Marked as Final)

If you downloaded the file or received it as an email attachment, Excel opens it in Protected View. A yellow bar appears just below the ribbon with a button that reads Edit Anyway. Clicking this button immediately removes the read-only restriction for that session.

If the file is marked as Final, the same yellow banner offers the same button. Once clicked, the warning bar disappears and the file behaves as any normal workbook. This fix takes one second and requires no passwords or permissions.

Fix 2: The Windows Attribute (File-Level Lock)

Some files are locked at the operating system level. Right-click the Excel file in File Explorer and choose Properties. On the General tab, look for the Attributes section. If Read-only is checked, uncheck it and click OK. This tells Windows the file is allowed to be modified. After this change, Excel will accept edits and saves without complaint.

Fix 3: Removing a Saved Password

When the creator of the file set a “Read-only recommended” password or a full modification password, you need to clear it. Open the file. Go to File > Save As. In the Save As dialog, click the Tools dropdown (next to the Save button) and select General Options. Delete the password in the “Password to modify” field and uncheck Read-only recommended. Click OK, then Save, confirming the replacement of the existing file. This is the official method documented by Microsoft.

Fix 4: Unprotecting a Specific Sheet

Sometimes the workbook itself opens fine, but individual cells or sheets are locked. This is sheet-level protection. Click the Review tab on the ribbon and select Unprotect Sheet. You will need the password if one was set when the protection was enabled. Once unprotected, all cells in that sheet become editable.

Fix 5: Killing the Ghost Lock File

After a crash or network dropout, Excel sometimes leaves behind a hidden file that it uses to track who has the file open. This ghost file tricks Excel into thinking you (or someone else) still have it open. To fix it, close Excel completely. Open File Explorer and enable Hidden items in the View tab. Navigate to the folder containing your Excel file. Look for a file named ~$filename.xlsx (where “filename” matches your actual file name). Delete this file. Reopen your Excel workbook—the read-only lock will be gone.

Fix 6: Network & Co-Authoring Conflicts

If the file lives on a shared network drive or a cloud folder, another user may have it open. Excel grants editing rights to the first session and locks everyone else out. The simplest fix is to ask the other person to close the file. If you have administrative access to the server, you can use the Microsoft Management Console (MMC) to close the open file remotely. For Microsoft 365 files, co-authoring should handle this automatically—if it doesn’t, have everyone save and close, then reopen.

What NOT to Do (Common Mistakes)

A few well-intentioned fixes make the problem worse. The table below shows the traps to avoid.

Which Fix Do You Need?

If you see a yellow banner, click Edit Anyway—that handles most cases. If the file retains the lock after that, check the Windows Properties. If it asks for a password, use the Save As method. If a specific sheet is locked, use the Review tab. If you get the “in use by me” error, delete the hidden ~$ file. If it’s a network conflict, ask the other user to close the file. Each lock has exactly one clean fix, and you now have the steps for all six.