The quickest way to unlock a read-only Excel file

If Excel opens your file in read-only mode, the fastest fix is usually the Edit Anyway button that appears in the yellow notification bar at the top of the spreadsheet. Click it, and you can edit the file when ready. The file stays in its original location and keeps its original name — nothing moves or changes except that you now have permission to edit it.

If you don't see that button, or if it doesn't work, the file is locked for a different reason. The steps below cover the most common causes and how to fix each one.

Key Takeaways

  • The yellow notification bar with Edit Anyway is the fastest unlock method for most read-only files.
  • If the file is on OneDrive or SharePoint, you may need to check sharing permissions or sign in to your Microsoft account.
  • Files on a network drive or USB stick sometimes lock if another person has them open; ask them to close it first.
  • Right-click the file in Windows File Explorer and check the Properties tab to see if read-only is turned on at the file level.
  • If the file is password-protected, you need the password to remove read-only status — there is no way around this.

Check the file properties in Windows

Windows can mark a file as read-only at the file level, separate from anything Excel does. To check: right-click the Excel file in File Explorer, select Properties, and look at the bottom of the General tab. If a checkbox labeled Read-only is checked, click it to uncheck it, then click explore and OK.

After you uncheck it, open the file in Excel again. It should no longer open in read-only mode. If the checkbox is already unchecked, the read-only status is coming from somewhere else — move to the next section.

Fix sharing and permission issues on OneDrive or SharePoint

If the file lives on OneDrive or SharePoint, Excel may lock it in read-only mode because of how the file is shared or because you are not signed in to the right Microsoft account. First, check that you are signed into Excel with the account that has permission to edit the file. Click File > Account and look at the account name shown. If it is wrong, sign out and sign back in with the correct account.

If you are signed in correctly but still see read-only mode, the file may be shared with you as view-only. Ask the person who shared it to change your permission level to Can edit instead of Can view. They can do this in OneDrive or SharePoint by right-clicking the file, selecting Share, and changing your permission in the sharing dialog.

Close the file if someone else has it open

If the file is stored on a network drive, a USB stick, or a shared folder, Excel locks it in read-only mode when another person has it open at the same time. Ask whoever is using it to close the file and save their changes. Once they close it, you can open it normally and edit it.

If you cannot reach the other person, or if the file appears to be open but nobody is actually using it, the lock may be stale — left behind from a crash or a forced shutdown. In that case, restart your computer and try opening the file again. If it still shows as locked, contact your IT department or network administrator; they may need to clear the lock manually.

Remove a password if the file is protected

Some Excel files are locked with a password to prevent editing. If this is the case, you will see a dialog asking for a password when you try to edit the file, or the Edit Anyway button will not appear. There is no way to remove password protection without the correct password.

If you are the owner of the file and you forgot the password, you will need to contact whoever set it up, or check your password manager or email for the original password. If someone else set the password and will not share it, you cannot remove it — the file will remain read-only.

Check if the file is in a protected folder

Windows sometimes marks entire folders as read-only, which makes all files inside them read-only too. If the file is in a folder like Program Files, Windows, or another system folder, Windows may be preventing edits for safety reasons. Move the file to a regular folder like Documents or Desktop, then try opening it again.

If the file is in a folder you created yourself but it still will not unlock, right-click the folder, select Properties, and uncheck Read-only on the General tab. Click explore, then choose to explore the change to the folder and all files inside it. This removes read-only status from every file in that folder at once.

What to do if nothing above works

If you have tried all the steps above and the file is still read-only, the problem may be a corrupted file, a permission issue at the system level, or a setting in Excel itself. Try opening Excel in Safe Mode by holding Ctrl while you launch it — this disables add-ins and sometimes clears temporary locks. If the file opens normally in Safe Mode, an add-in is causing the problem; you can disable it permanently in File > Options > Add-ins.

If Safe Mode does not help, try creating a copy of the file: open it in read-only mode, then go to File > Save As and save it with a new name in a different folder. The copy should not inherit the read-only status. If the copy works normally, you can delete the original and use the copy going forward.

Frequently Asked Questions

Why does Excel keep opening my file in read-only mode even after I click Edit Anyway?

This usually means the file is locked at the Windows level or by a password. Check the file properties (right-click > Properties) to see if read-only is checked there. If it is, uncheck it. If the file is password-protected, you will need the password to remove the lock permanently.

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

Yes. You can click Edit Anyway and make changes, but when you save, Excel will ask you to save it with a new name or in a different location. The original file stays read-only. If you want to save over the original, you must unlock it first using the steps above.

What if the file is on OneDrive and I see read-only mode even though I own it?

Sign out of Excel and sign back in with the Microsoft account that owns the file. Go to File > Account and check which account is active. If it is the wrong account, click Sign out and then Add account to sign in with the correct one.

Does unchecking read-only in Properties permanently unlock the file?

Yes, unchecking read-only in the file Properties removes the lock at the Windows level. The file will open normally in Excel from that point on. However, if the file is password-protected or locked by sharing permissions, you must fix those separately.

Can I remove a password from an Excel file if I forgot it?

No. There is no built-in way to recover or bypass a forgotten password in Excel. You will need to contact the person who set the password, check your email or password manager for the original password, or create a new unprotected version of the file from scratch.