Why Your Excel File Is Read-Only and How to Fix It

An Excel file becomes read-only when Windows or the file itself is set to prevent editing. This happens for several reasons: the file properties are marked read-only, the file is stored on a read-only drive or network location, another user has it open, or Excel opened it in read-only mode as a safety measure. The fix depends on which of these is actually blocking you.

The fastest way to check is to look at the title bar of Excel. If it says "[Read-Only]" next to the filename, the file itself is locked. If you can edit but get a warning when you try to save, the file location is the problem. Start there, then move through the steps below in order.

Key Takeaways

  • Check the Excel title bar first — if it says "[Read-Only]", the file properties are locked, not the location.
  • Right-click the file in Windows File Explorer, select Properties, and uncheck the Read-only box under Attributes to unlock most files.
  • If the file is on a network drive or shared folder, you may need permission from the person who shared it or the network administrator.
  • If another user has the file open, close it on their computer or ask them to close it before you can edit your own copy.
  • Save a copy of the file to your own computer if you cannot get write permission on the original location.

Unlock the File Using Windows Properties

This is the most common fix and works when the file itself is marked read-only. Close Excel completely first — do not just close the document, close the entire program. Then open File Explorer and navigate to the folder where your Excel file is stored.

Right-click the filename and select Properties from the menu. In the Properties window, look at the bottom of the General tab for Attributes. You will see a checkbox next to "Read-only". If it is checked, click it to uncheck it, then click explore and OK. Open the file in Excel again — it should no longer be read-only.

If the Read-only checkbox is grayed out and you cannot click it, the file is locked by Windows or another program. Close any other programs that might be using the file, restart your computer, and try again. If it remains grayed out, the file may be on a protected drive or network location — move to the next section.

Check Whether Another User Has the File Open

If the file is stored on a shared network drive or in a shared folder like OneDrive or SharePoint, another person may have it open. Excel will not let two people edit the same file at the same time, so it locks the file for everyone except the person currently editing it.

Ask anyone else who might be working on the file to close it. They do not need to save — just close Excel or close that specific document. Once they close it, wait 30 seconds, then try opening it again on your computer. You should now be able to edit it.

If you do not know who has it open, check the file's version history or sharing settings. In OneDrive or SharePoint, right-click the file and select Version history or Details to see who opened it most recently. On a network drive, your IT department or network administrator can tell you which computer has the file locked.

Save a Copy to Your Computer If You Cannot Get Permission

If the file is on a network drive or shared location and you do not have write permission, you cannot edit it in place. Instead, save a copy to your own computer where you have full control. Open the file in Excel, go to File > Save As, and choose a folder on your local hard drive (like Documents or Desktop).

Give the copy a new name so you do not confuse it with the original. Work on your copy, then when you are done, you can email it back to the person who shared the original, or ask the file owner to give you write permission on the network location. Do not edit the original file on the network drive and the copy on your computer at the same time — you will end up with two different versions and lose work.

Handle Read-Only Mode When Excel Opens the File

Sometimes Excel opens a file in read-only mode as a safety measure, even though the file itself is not locked. This usually happens when the file was not closed properly the last time it was open, or when Excel detects that another user might be editing it. You will see a yellow banner at the top of the spreadsheet that says "This file is in read-only mode" with an Edit Anyway button.

Click Edit Anyway to switch to edit mode. Excel will ask you to confirm, and the file will unlock. If you do not see the banner, go to File > Info and look for a button that says Edit Anyway or Enable Editing. Click it to unlock the file.

If the button does not appear and the file is still locked, the file location itself may be read-only. Check whether the folder is on a protected drive, a read-only network share, or a cloud service where you do not have edit permission. If so, follow the steps in the "Save a Copy to Your Computer" section above.

Unblock a File Downloaded from the Internet

When you read a file from the internet or receive it as an email attachment, Windows may mark it as unsafe and block it from running or editing. You will see a message in Excel that says the file is in read-only mode, or the file will not open at all.

To unblock it, close Excel, right-click the file in File Explorer, and select Properties. At the bottom of the General tab, you may see a checkbox that says "Unblock" with text that reads "This file came from another computer and may be blocked to help protect your computer." Check the Unblock box, click explore, and click OK. Open the file in Excel again — it should now be editable.

If you do not see an Unblock checkbox, the file is not blocked by Windows. The read-only status is coming from the file itself or its location, so go back to the "Unlock the File Using Windows Properties" section and follow those steps.

Frequently Asked Questions

What if I uncheck Read-only in Properties but it stays checked when I open Properties again?

The file may be on a read-only drive, or another program may be locking it. Close all programs that might be using the file, including cloud sync apps like OneDrive or Dropbox. Restart your computer and try unchecking it again. If it still will not stay unchecked, the folder or drive itself is read-only — contact your IT department or network administrator.

Can I edit a read-only file without changing it to read-write?

No. You can view a read-only file and copy data from it, but you cannot save changes to the original file. You can only save your changes if you save the file with a new name using Save As, which creates a new copy that you can edit.

Will changing a file from read-only to read-write affect other people who are using it?

If the file is on a shared network drive or cloud service, changing the file properties on your computer does not change the permissions for other users. Each person's access depends on the folder or file sharing settings, which are controlled by the file owner or network administrator. If you want to give someone else write permission, ask the file owner to change the sharing settings.

Why does Excel say the file is read-only when I open it, but the Properties checkbox is unchecked?

The file location itself is read-only, not the file. This happens when the file is on a protected network drive, a read-only cloud folder, or a drive that Windows has marked as read-only. Save a copy of the file to your Documents folder or Desktop, where you have full write permission, and work on the copy instead.