Why Your Excel File Is Locked in Read-Only Mode

Excel opens a file in read-only mode for three main reasons: the file properties are set to read-only, the file is stored in a protected location, or Excel itself opened it that way as a safety measure. When a file opens in read-only mode, you can view and copy the data, but you cannot edit, save changes, or add new information to the spreadsheet. The title bar will display "[Read-Only]" next to the filename.

The most common cause is that the file's read-only attribute is turned on in Windows or Mac file properties. A second cause is that the file lives in a system folder like Program Files or a cloud sync folder that has restricted permissions. A third cause is that Excel detected the file was not closed properly the last time it was open, so it opened it in read-only as a precaution.

Key Takeaways

  • Check the file properties on your computer first — right-click the file, select Properties, and uncheck the read-only box if it is marked.
  • If the file is in OneDrive or SharePoint, you may need to check sharing permissions or click "Edit" in the browser before you can make changes in Excel.
  • If Excel shows a yellow notification bar saying the file is in read-only mode, click "Edit Anyway" to unlock it for editing.
  • Moving the file out of a system folder like Program Files or Desktop to a regular folder like Documents often removes the read-only restriction.
  • If the file is password-protected, you will need the password to remove read-only mode — there is no way around this without the password.

Check the File Properties on Windows

The fastest way to remove read-only mode is to change the file's properties on your computer. Right-click the Excel file in File Explorer, then select Properties from the menu. Look for a checkbox labeled Read-only near the bottom of the window, usually in the Attributes section.

If the read-only box is checked, click it to uncheck it. Then click explore and OK. Close the file if it is open in Excel, then open it again. The file should now open in edit mode instead of read-only mode. If the checkbox is already unchecked, the read-only status is coming from a different source — move to the next section.

Check File Permissions on Mac

On a Mac, right-click the Excel file and select Get Info. Scroll down to the Sharing & Permissions section at the bottom of the window. Look at the permission level next to your username — it should say Read & Write.

If it says Read only, click the lock icon at the bottom right of the window to unlock it (you may need to enter your Mac password). Then click the dropdown next to your username and change it to Read & Write. Close the Get Info window and try opening the file in Excel again.

Click "Edit Anyway" If Excel Shows a Notification

When you open a file that Excel suspects was not closed properly, it displays a yellow notification bar at the top of the spreadsheet. The message usually reads "This file was not saved properly. Would you like to recover the contents?" or "This file is in read-only mode." Below that message is a button labeled Edit Anyway.

Click Edit Anyway to unlock the file for editing. Excel will switch out of read-only mode when ready, and you can begin making changes. This is the simplest fix when Excel itself is the reason the file opened in read-only mode.

Move the File to a Standard Folder

If the file is stored in a system folder like Program Files, Windows, or a protected cloud sync folder, Windows or Mac may restrict editing permissions. Try moving the file to a standard folder like Documents or Desktop. Right-click the file, select Cut, navigate to Documents, right-click in the empty space, and select Paste.

Once the file is in a standard folder, open it in Excel again. If the file is in OneDrive or SharePoint, the issue is different — see the next section instead. Moving the file may also help if it is stored on an external drive or a network location with limited permissions.

Check Sharing Permissions for OneDrive and SharePoint Files

If the file is stored in OneDrive or SharePoint, read-only mode often means you do not have edit permission for that file. Open the file in your web browser first by going to OneDrive.com or your SharePoint site. Find the file and click it to open it in the browser version of Excel.

If the browser shows an Edit button, click it to switch to edit mode. If you see a message saying you do not have permission to edit, the file owner has restricted your access to view-only. You will need to contact the file owner and ask them to change your permission level to Can edit. Once they do, you will be able to edit the file in both the browser and the desktop version of Excel.

Remove Password Protection If the File Is Locked

If the file is password-protected, Excel will not let you remove read-only mode without the correct password. When you try to edit the file, Excel displays a dialog asking for the password. There is no legitimate way to remove password protection without the password — if you have forgotten it, you will need to contact the person who set it or use the file in read-only mode.

If you do have the password, enter it when Excel prompts you. The file will unlock and switch to edit mode. If you want to remove the password entirely so the file does not ask for it again, go to File > Info > Protect Workbook and select Encrypt with Password. Delete the password text and click OK.

Frequently Asked Questions

Why does my file keep opening in read-only mode even after I unchecked the read-only box?

The file may be in a protected folder, or Excel may be opening it in read-only mode as a safety measure. Try moving the file to Documents or Desktop. If it still opens in read-only mode, check whether the file is password-protected or stored in OneDrive with view-only permissions.

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

Yes. When Excel opens a file in read-only mode, you can click File > Save As and save it with a new name. This creates an editable copy while leaving the original read-only file untouched.

What if I do not have permission to change the file properties?

You may not have administrator rights on your computer. Try saving the file with a new name using File > Save As, which often bypasses read-only restrictions. If that does not work, contact your IT support or computer administrator.

Does removing read-only mode affect other people who have the file open?

No. Changing the read-only setting on your computer affects only your copy of the file. If the file is shared on OneDrive or SharePoint, other people's access is controlled by the sharing permissions the owner set, not by your local file properties.

Can I make a read-only file editable in Excel without changing the file itself?

Yes. Open the file, then go to File > Save As and save it with a new name to a folder where you have write permission. The new copy will be fully editable, and the original read-only file remains unchanged.