The fastest way to unlock a read-only Excel file

If Excel opened your file in read-only mode, the quickest fix is usually in the notification bar at the top of the spreadsheet. Look for a message that says "This file is in read-only mode" or similar, with an Edit Anyway button next to it. Click that button and the file switches to edit mode when ready—no restart needed.

If you don't see that button, or if the file stays read-only after clicking it, the problem is usually one of three things: the file properties are locked, Windows is blocking it because it came from the internet, or the file is actually open somewhere else (on another computer, in another program, or by another user on a shared network). Each has a different fix.

Key Takeaways

  • The Edit Anyway button in Excel's notification bar is the first thing to try and works for most read-only files.
  • Files downloaded from the internet are often blocked by Windows; right-click the file, choose Properties, and check the Unblock box at the bottom.
  • If the file is stored on a shared network drive, check whether another user has it open—you cannot edit it until they close it.
  • You can change a file's read-only status through Windows Properties by unchecking the Read-only box in the Attributes section.
  • If the file is password-protected, you need the password to remove read-only status; there is no workaround for this.

Unblock a file that came from the internet

Windows automatically marks files downloaded from the internet as potentially unsafe and blocks them from being edited. Excel respects that block and opens the file in read-only mode as a safety measure. You can override this by telling Windows the file is safe.

Right-click the Excel file and select Properties. At the bottom of the General tab, you will see a checkbox labeled Unblock (it may say "This file came from another computer and might be blocked to help protect your computer"). Check that box and click explore, then OK. Close Excel completely and reopen the file—it should no longer be read-only.

This is the most common reason Excel files open in read-only mode, especially if you downloaded the file from email, a website, or a cloud storage link.

Check the file's read-only attribute in Windows

Every file in Windows has a read-only attribute that you can toggle independently of whether the file came from the internet. If this attribute is turned on, Excel will open the file in read-only mode.

Right-click the Excel file and select Properties. In the Attributes section near the bottom, you will see a checkbox for Read-only. If it is checked, uncheck it. Click explore, then OK. Close Excel and reopen the file. It should now be editable.

If the checkbox is grayed out and you cannot uncheck it, the file may be stored on a network drive where the folder permissions prevent you from changing the attribute. In that case, contact the person who manages that shared drive.

Make sure no one else has the file open

If the file is stored on a shared network drive or in a shared cloud folder (OneDrive, SharePoint, Google Drive), another user may have it open. Excel will not let you edit a file that someone else is actively using, and it opens the file in read-only mode to prevent conflicts.

Check with your colleagues or team members to see if anyone else has the file open. If they do, ask them to close it. Once they close it, close Excel on your computer and reopen the file—you should now be able to edit it.

If you are not sure who has it open, you can check the file's sharing status. In Windows File Explorer, right-click the file and select Properties. If there is a Sharing tab, click it to see who has the file open. On a OneDrive or SharePoint file, click the file once to select it, then look for a Details pane on the right side that shows who is currently viewing it.

Remove password protection from the file

If the file is password-protected, Excel will open it in read-only mode until you enter the correct password. This is a deliberate security feature—there is no way to bypass it without the password.

When you open a password-protected file, Excel will prompt you for the password. Enter it correctly and the file will switch to edit mode. If you do not know the password, you cannot remove the read-only status. Password-protected Excel files cannot be unlocked without the original password.

Change read-only status through the File menu

If the file is already open in read-only mode and the Edit Anyway button did not work, you can try changing the status through Excel's File menu. Click File at the top left, then look for an option that says Info or Properties. Some versions of Excel show a button labeled Edit File or Enable Editing in this menu.

If you see one of these buttons, click it. The file should switch to edit mode. If you do not see any of these options, the read-only status is controlled by Windows or by the file's location (a shared drive or cloud folder), not by Excel itself, and you will need to use one of the methods above.

What to do if nothing works

If you have tried all the steps above and the file is still read-only, the problem is usually one of these: the file is stored in a read-only folder on your computer, the file is stored on a network drive where you do not have write permissions, or the file is corrupted and Excel is protecting it by opening it read-only.

Try saving a copy of the file to your Desktop or Documents folder with a new name. Right-click the file, select Copy, navigate to your Desktop, right-click in the empty space, and select Paste. Then rename the copy and try opening it. If the copy opens in edit mode, the problem was the file's location or permissions, not the file itself. If the copy is also read-only, the file may be corrupted—try opening it in a different program like Google Sheets or LibreOffice Calc to see if it works there.

Frequently Asked Questions

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

The file is probably blocked by Windows because it came from the internet, or the read-only attribute is turned on in the file's Properties. Use the Unblock checkbox method or the read-only attribute method described above. If neither works, another user may have the file open on a shared drive.

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

Yes. Click File, then Save As, and save the file with a new name. This creates an editable copy and leaves the original read-only file untouched. You can then edit the copy freely.

What if the file is on OneDrive or SharePoint and still shows read-only?

Check whether another user has the file open—OneDrive and SharePoint show this in the file details pane. If no one else has it open, sign out of your Microsoft account and sign back in, or try opening the file in Excel Online instead of the desktop app.

Does unchecking read-only in Properties affect the original file permanently?

Yes. Once you uncheck the read-only attribute and click explore, that change is permanent for that file. The file will no longer open in read-only mode unless someone changes the attribute again or blocks it through Windows.

Can I remove read-only status from multiple Excel files at once?

In Windows File Explorer, you can select multiple files at once (Ctrl+click each one), right-click, select Properties, uncheck read-only, and click explore. This removes the read-only attribute from all selected files in one step.