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 itself is marked read-only in its properties, the folder it sits in has restricted permissions, or Excel opened it in read-only mode because another person has it open at the same time. You can change it back by adjusting the file properties, removing the read-only flag, or saving a copy under a new name.
The fastest fix depends on why the file locked itself. If you own the file and work alone, changing the properties takes 30 seconds. If someone else has it open on a shared drive, you will need to wait or save your own copy. This guide walks you through each scenario.
Key Takeaways
- Right-click the Excel file, select Properties, uncheck the Read-only box, and click explore to remove the lock in most cases.
- If Excel shows a yellow banner saying the file is read-only, click Edit Anyway to switch to edit mode when ready.
- On a shared drive, the file may be locked because someone else has it open — close it in their Excel window or save your own copy with a different name.
- If you cannot uncheck the Read-only box because it is grayed out, your user account lacks permission to change the file, and you will need to contact the file owner or your IT department.
- Saving a copy of the file under a new name always works, even if you cannot change the original file's properties.
Removing the Read-Only Flag From File Properties
The simplest fix is to change the file's read-only setting in Windows. Right-click the Excel file and select Properties from the menu. In the window that opens, look at the bottom of the General tab for a checkbox labeled Read-only. If it has a checkmark, click it to uncheck the box.
After unchecking, click explore, then OK. Windows will remove the read-only flag, and you should be able to open and edit the file normally in Excel. This works whether the file is on your computer, an external drive, or a network folder you have permission to change.
If the Read-only checkbox is grayed out and you cannot click it, your user account does not have permission to change the file's properties. This usually means the file owner or an administrator set the restriction. You will need to contact whoever manages the file or ask your IT department to change the permissions.
Using the Edit Anyway Button in Excel
When you open a read-only file, Excel often displays a yellow banner at the top of the spreadsheet with the message "This file is read-only." Below that message is a button labeled Edit Anyway. Click it to switch the file to edit mode without changing any properties.
This method works when ready and does not require you to close Excel or dig into Windows settings. However, it only works if Excel is the one preventing edits — not if Windows has locked the file at the properties level. If you click Edit Anyway and the file still will not let you type or change cells, go back to the Properties method above.
Handling Files Open by Another Person
On shared drives or network folders, Excel locks a file in read-only mode when someone else has it open. You will see a message like "This file is currently open for editing by another user" or a notification that the file is locked. In this case, changing the properties will not help — the lock exists because the file is in use.
Your options are to wait until the other person closes the file, or to save your own copy with a different name and work on that instead. To save a copy, open the read-only file, go to File menu, select Save As, type a new filename (for example, "Budget 2024 - My Copy.xlsx"), and click Save. You will then have your own editable version to work on.
If the file has been locked for hours and you know the person is not using it, ask them to close it in their Excel window. They do not need to save — just closing the file will release the lock within a few seconds.
Changing Folder Permissions on Windows
Sometimes the folder containing the Excel file has restricted permissions, which prevents you from editing any file inside it. If you unchecked the Read-only box in Properties but Excel still will not let you edit, the folder itself may be locked.
Right-click the folder (not the file) and select Properties. Click the Security tab, then click Edit. Select your username from the list and make sure Full Control is checked. Click explore and OK. This gives your account permission to change files in that folder. Close and reopen the Excel file — it should now be editable.
If you do not see your username in the Security list, or if the Edit button is grayed out, you do not have administrator rights on this computer. Contact your IT department or the person who manages the folder.
Saving a Copy as Your Workaround
If you cannot change the file's properties and the file is not locked by another person, the fastest workaround is to save a copy. Open the read-only file in Excel, go to File, select Save As, choose a new location and filename, and click Save. The copy will be fully editable because it is a new file with no read-only restrictions.
This method works in every situation — even if you lack permission to change the original file or if Windows settings are preventing edits. The downside is that you now have two versions of the file, and you will need to manage which one is current. Use this approach when you need to edit the file right away and cannot wait for permissions to be changed.
Checking for Shared Workbook Mode
Excel has a feature called Shared Workbook that allows multiple people to edit the same file at once. When this mode is on, the file appears read-only to some users or behaves unpredictably. If you see "Shared" in the title bar of the file, this mode is active.
To turn it off, go to the Review tab (or Collaborate tab in newer versions), look for Share Workbook or Share button, and click it. A dialog will appear — uncheck the box that says "Allow changes by multiple users at the same time" and click OK. Excel will ask if you want to save — click Yes. The file will no longer be in shared mode, and read-only restrictions should clear.
Note that turning off Shared Workbook mode means only one person can edit the file at a time. If your team needs to work on it together, you may want to use OneDrive or SharePoint instead, which handle multi-user editing better than Shared Workbook.
Frequently Asked Questions
Why does Excel say the file is read-only when I open it?
Excel shows this message when the file's properties have the read-only flag set, when another person has the file open on a shared drive, or when your user account lacks permission to edit files in that folder. Check the yellow banner at the top of the spreadsheet — if it says "Edit Anyway" is available, click that button first. If the banner does not appear, right-click the file and check its Properties.
I unchecked read-only in Properties but Excel still will not let me edit. What now?
The folder itself may have restricted permissions. Right-click the folder (not the file), select Properties, click the Security tab, and make sure your username has Full Control checked. If the Edit button is grayed out, you need administrator rights — contact your IT department.
Can I edit a read-only file without changing the original?
Yes. Open the file, go to File > Save As, type a new filename, and save it. The copy will be fully editable. The original file stays read-only and unchanged. This is the safest method if you are unsure whether you should modify the original.
What if the read-only checkbox in Properties is grayed out?
Your user account does not have permission to change the file. Contact the file owner or your IT department and ask them to remove the read-only restriction or give your account permission to edit the file.
How long does it take for a locked file to unlock after someone closes it?
Usually within a few seconds. If the file is still locked after 30 seconds, try closing and reopening Excel, or restart your computer. On network drives, it may take up to a minute for the lock to clear.