Why your Excel file is stuck in read-only mode

Excel locks a file as read-only for three main reasons: the file properties are set to read-only, the file is stored in a protected location like OneDrive or a shared drive, or the file is already open by someone else on a network. When a file is read-only, you can view it and make changes on your screen, but Excel will not let you save those changes back to the original file. You will see a yellow banner at the top saying "Read-Only" or get a dialog box when you try to save.

The fix depends on which of these three situations you are in. Most of the time, the solution takes less than a minute.

Key Takeaways

  • Check the file properties on your computer first — right-click the file, select Properties, and uncheck the Read-only box if it is marked.
  • If Excel shows a yellow banner at the top, click "Edit Anyway" to switch out of read-only mode immediately.
  • Files stored on OneDrive or SharePoint may open read-only if you do not have edit permission or if the file is already open elsewhere.
  • If someone else has the file open on a shared network, close it on their computer or ask them to save and close it first.
  • Saving a read-only file as a new file with a different name always works, but you will have two copies instead of one.

The fastest fix: click "Edit Anyway" in the yellow banner

When you open a read-only Excel file, Excel usually shows a yellow information bar near the top of the window. This bar says "Read-Only" and offers an "Edit Anyway" button on the right side. Click that button, and Excel will switch the file to edit mode immediately. You can then make changes and save normally.

This works for most read-only situations because Excel is simply warning you that the file came from a location it considers potentially unsafe — like an email attachment or a shared network folder. Clicking "Edit Anyway" tells Excel you trust the file and want to work with it.

Check the file properties on your computer

If there is no yellow banner, or if clicking "Edit Anyway" does not work, the read-only setting may be locked in the file's properties. This is a Windows or Mac setting, not an Excel setting.

On Windows: Right-click the Excel file in File Explorer. Select Properties from the menu. In the Properties window, look for a checkbox labeled "Read-only" near the bottom. If it is checked, click the checkbox to uncheck it. Then click Apply and OK. Close the Properties window and open the file again in Excel.

On Mac: Right-click the Excel file in Finder. Select Get Info from the menu. Look for a section called "Sharing & Permissions" at the bottom. If you see a lock icon, click it to unlock the file. Make sure your user account has Read & Write permission listed. Close the Get Info window and open the file again in Excel.

Move the file to a location where you have full permission

Files stored on OneDrive, SharePoint, or a shared network drive sometimes open as read-only if you do not have edit permission for that location, or if the file is already open by someone else. The fastest way to work around this is to save a copy of the file to your Desktop or Documents folder on your computer.

Open the file in Excel. Go to File menu and select Save As. Choose Desktop or Documents as the location. Give the file a new name if you want to keep the original, or use the same name to replace it. Click Save. Close the original file and work with the copy on your computer instead. Once you are done editing, you can move it back to the shared location if needed.

This method creates a separate copy, so use it only if you do not need to keep the file in its original shared location. If other people are also editing the file, this approach will create confusion because you will have two versions.

Check if someone else has the file open

On a shared network drive or OneDrive, Excel locks a file as read-only if another person has it open at the same time. You will usually see a message saying the file is in use by another user, with their name listed. The file will open in read-only mode until that person closes it.

Ask the person who has the file open to save their changes and close the file. Once they close it, close your copy of the file in Excel and open it again. This time it should open in edit mode. If you do not know who has it open, or if the name shown is a computer name rather than a person's name, the file may have been left open accidentally. Try waiting a few minutes and then opening it again — sometimes Excel will release the lock on its own.

Save the file with a new name to force it out of read-only

If none of the above steps work, you can always save the file as a new file with a different name. This removes the read-only restriction because you are creating a brand-new file rather than editing the original.

Open the read-only file in Excel. Go to File menu and select Save As. Type a new name for the file — for example, add "edited" or today's date to the original name. Click Save. Excel will save the file with the new name in edit mode. You can now make changes and save normally. The original read-only file will still exist, so delete it if you do not need it anymore.

Frequently Asked Questions

Why does Excel keep opening my file as read-only even after I unchecked the box in Properties?

The file may be stored in a protected folder like Program Files or a OneDrive sync folder that resets permissions. Try moving the file to your Documents or Desktop folder and unchecking read-only again. If it is on OneDrive, check your permission level for that folder — you may need edit permission from the folder owner.

Can I edit a read-only file without saving over the original?

Yes. Make your changes in Excel, then go to File and select Save As. Give it a new name and save it as a separate file. The original read-only file stays unchanged, and you have a new edited copy.

What does it mean if Excel says the file is "locked for editing"?

This means someone else has the file open on a shared drive or OneDrive. You can view the file but cannot edit it until they close it. Ask them to save and close the file, then close and reopen it on your end.

Is it safe to click "Edit Anyway" on a file I do not recognize?

Only if you trust where the file came from. If someone sent you a file via email and you did not expect it, or if it came from an unknown source, do not click "Edit Anyway" — it could contain malware. Delete it or scan it with antivirus software first.