Why Your Excel File Is Locked and How to Unlock It

An Excel file becomes read-only when Windows or the file's properties prevent you from editing it. This happens for three main reasons: the file is marked as read-only in its properties, it is stored in a protected folder, or it opened in read-only mode because another user has it open. The fix depends on which one applies to you.

The fastest way to check is to look at the title bar of Excel itself. If it says "Read-Only" next to the filename, you are in read-only mode. If you can edit but cannot save, the file properties are locked. Both are fixable in under a minute.

Key Takeaways

  • Check the Excel title bar first — if it says "Read-Only" next to the filename, the file opened in read-only mode and you can switch it when ready.
  • Right-click the file in File Explorer, select Properties, and uncheck the "Read-only" box if the file itself is marked as read-only.
  • If another user has the file open on a shared network, you must wait for them to close it or ask them to close it before you can edit.
  • Files in OneDrive or SharePoint may open read-only if you do not have edit permissions — check the sharing settings or ask the file owner.
  • Saving a copy of the file to your own computer removes read-only restrictions that come from shared drives or network locations.

Remove Read-Only Mode When the Title Bar Shows It

If the Excel title bar displays "Read-Only" next to the filename, the file opened in read-only mode but you can switch it. This usually happens when another person has the file open at the same time, or when you opened it from an email attachment or a read-only location.

Click the Edit Anyway button in the yellow banner at the top of the spreadsheet. Excel will switch to edit mode when ready. If there is no banner, go to File menu, then look for an Edit Workbook button near the top. Click it and the file will unlock.

If neither button appears, the file is truly locked by another user. You will need to wait until they close it, or ask them to close it if you know who they are. Check with your team or the file owner before trying other methods.

Uncheck Read-Only in the File Properties

If you can edit the file but cannot save changes, the file itself is marked as read-only in Windows. Open File Explorer and locate the Excel file. Right-click it and select Properties at the bottom of the menu.

In the Properties window, look at the bottom of the General tab. You will see a checkbox next to "Read-only". If it is checked, click it to uncheck it, then click explore and OK. Close Excel completely and reopen the file — you should now be able to save normally.

If the checkbox is grayed out and you cannot click it, your user account does not have permission to change the file. This usually means the file is in a protected folder or belongs to another user. Move the file to your Documents folder or Desktop, then try unchecking read-only again.

Move the File Out of Protected Folders

Some Windows folders, like Program Files or the root of your C: drive, prevent you from editing files stored in them. If your Excel file is in one of these locations, Windows will not let you save changes even if you uncheck read-only in properties.

The solution is to move the file to a folder you control. Right-click the file in File Explorer, select Cut, then navigate to your Documents folder or Desktop. Right-click in the empty space and select Paste. Open the file from its new location and try saving — it should work now.

If you cannot cut the file because Windows says you do not have permission, the file may belong to the Administrator account. Right-click the file, select Properties, go to the Security tab, and click Edit. Select your username, check the Full Control box, then click explore and OK. You should then be able to move or edit the file.

Handle Shared Files on OneDrive or SharePoint

Files stored on OneDrive or SharePoint sometimes open read-only if you do not have edit permissions. Check the top of the Excel window for a message saying you have view-only access. If you see this, you need the file owner to change your permissions.

Contact the person who shared the file with you and ask them to give you edit access. They can do this by right-clicking the file in OneDrive or SharePoint, selecting Share, and changing your permission level from "View" to "Edit". Once they do, close and reopen the file in Excel.

If you own the file but it is still read-only, try saving a copy to your computer instead. In Excel, go to File > Save As, choose a location on your local drive (like Documents), and save it with a new name. You will have full edit access to the copy.

Save a Copy to Your Computer

The fastest way to remove all read-only restrictions is to save a copy of the file to your own computer. This works whether the file is on a network drive, a shared folder, or a cloud service. Open the file in Excel, go to File menu, and click Save As.

In the Save As dialog, click the folder dropdown at the top and select This PC. Then choose a location like Documents or Desktop. Give the file a new name (or keep the same name) and click Save. Excel will create a copy on your computer with no read-only restrictions.

You can now edit and save this copy freely. If you need to send changes back to the original location, you can copy the file back or email it to whoever manages the shared folder. This method also works if you are unsure why the file is read-only — it bypasses the problem entirely.

Check for Shared Access and Network Locks

On a shared network drive, a file stays read-only if another person has it open. Windows locks the file to prevent two people from saving over each other's changes. You cannot edit it until they close it.

Ask the person using the file to save and close it. If you do not know who has it open, check the file's details in File Explorer. Right-click the file, select Properties, and look at the "Date modified" field — if it is recent, someone may still be working on it. Wait a few minutes and try again.

If the file has been locked for hours and you know the person is not using it, they may have left it open by accident. In that case, you can save a copy to your computer (using the method above) and work on that instead. Coordinate with them later to merge changes if needed.

Frequently Asked Questions

Can I remove read-only if I do not own the file?

If the file is marked read-only in its properties, you can uncheck it if your user account has permission. If it is on a shared drive or OneDrive, you need the owner to change your access level. Saving a copy to your computer always works, but you will be editing a separate version.

What if I uncheck read-only but it stays read-only?

The file may be in a protected folder like Program Files. Move it to Documents or Desktop and try again. If it is on a network drive, save a copy to your computer. If another user has it open, you must wait for them to close it first.

Does removing read-only affect other people using the file?

No. Unchecking read-only on your copy only affects your access. If the file is on a shared drive, other users still see their own copy's properties. If you are both editing the same file at once, one person's changes will overwrite the other's when you save.

Why does my file keep opening as read-only?

It may be stored in a protected folder, on a shared drive where you have view-only access, or another user keeps opening it. Check the file location and your permissions. If it is in a protected folder, move it to Documents. If it is shared, ask the owner for edit access.

Is it safe to save a copy of a shared file?

Yes. You will have a separate version on your computer that you can edit freely. If you need to update the original file, you can copy your changes back or email the updated version to whoever manages the shared folder.