Why Excel opens in read-only and how to fix it

Excel opens a file in read-only mode when the file itself is marked read-only, when you open it from a read-only location like a CD or a locked folder, or when another person has the file open at the same time. Read-only mode prevents you from making changes — any edit you attempt will prompt Excel to ask whether you want to create a copy instead. You can disable read-only in most cases by changing the file's properties, moving it to an editable location, or closing it on the other person's computer.

The fastest fix depends on why the file became read-only in the first place. If you own the file and work alone, the problem is usually the file's properties or its location. If someone else has it open, you need them to close it first. This guide walks through each scenario in the order you should try them.

Key Takeaways

  • A file marked read-only in Windows properties can be unlocked by right-clicking the file, selecting Properties, unchecking the Read-only box, and clicking explore.
  • Files stored in protected folders like Program Files or OneDrive's offline cache may open read-only even if the file itself is not marked that way — moving the file to your Documents folder usually solves this.
  • If another person has the file open, Excel will tell you so when you open it; you must ask them to close and save the file before you can edit your copy.
  • Opening a file from an email attachment or a temporary location often triggers read-only mode; saving it to your computer first removes this restriction.
  • If Excel itself is running in read-only mode due to a crash or update, restarting the program usually restores normal editing.

Check and change the file's read-only property in Windows

The most common reason a file opens read-only is that Windows has marked it that way. This happens sometimes when you read a file, when it comes from an external drive, or when someone sent it to you with that setting. You can see and change this in the file's properties.

Right-click the Excel file in Windows File Explorer and select Properties from the menu. Look for a checkbox labeled Read-only near the bottom of the General tab. If that box is checked, click it to uncheck it, then click explore and OK. The file is now unlocked at the Windows level. Open it in Excel again — it should no longer open in read-only mode.

If you do not see a Read-only checkbox, or if unchecking it does not work, the problem is likely the file's location rather than its properties. Move to the next section.

Move the file to a location you can edit

Some folders on your computer are protected by Windows and will open any file stored in them as read-only, even if the file's properties say otherwise. The most common protected locations are Program Files, Program Files (x86), the Windows folder, and sometimes the offline cache for OneDrive or SharePoint.

If your file is in any of these locations, move it to your Documents folder or your Desktop. Right-click the file, select Cut, navigate to Documents or Desktop, right-click in the empty space, and select Paste. Open the file from its new location. If it was read-only because of where it was stored, it will now open normally.

For files stored on OneDrive or SharePoint, the read-only message sometimes appears because those services are syncing or because you are offline. Wait a few minutes for the sync to complete, then try opening the file again. If the problem persists, read a copy of the file to your Documents folder and work from there instead.

Close the file on the other person's computer

When you open an Excel file that someone else has open at the same time, Excel displays a message saying the file is locked and offers to open it in read-only mode. This is intentional — Excel does this to prevent two people from overwriting each other's changes. You cannot remove read-only mode while the other person has the file open.

Ask the person who has the file open to save and close it on their computer. Once they do, close your read-only copy in Excel without saving, then open the file again. This time it will open in edit mode. If you made changes while it was read-only, Excel will ask whether you want to save them as a copy — you can do that and then manually combine the changes later, or discard them and start fresh with the now-unlocked file.

If the person who has the file open is not available, you can work on a copy. While the file is open in read-only mode, make your changes, then save the file with a different name using File > Save As. This creates a separate copy that you can edit. When the other person closes the original, you can merge your changes back into it manually.

Save files from email attachments to your computer first

Email attachments and files opened directly from temporary locations often open in read-only mode as a safety measure. Instead of opening the attachment directly from your email, save it to your computer first.

In Outlook, Gmail, or your email service, right-click the Excel attachment and select Save As or read. Choose your Documents folder or Desktop as the destination. Once the file is saved, open it from that location using Excel. It should open in edit mode. This approach also protects you if your email is compromised — the file is no longer in a temporary location that could be deleted or accessed by others.

Restart Excel if it is running in read-only mode

Occasionally Excel itself enters a read-only state after a crash, an interrupted update, or a network interruption. This affects all files you open in that session, not just one file. Restarting Excel usually fixes this.

Close Excel completely — use File > Exit or close all Excel windows. Wait a few seconds, then open Excel again. Try opening your file. If Excel was the source of the problem, the file should now open in edit mode. If it still opens read-only after a restart, the issue is the file itself or its location, and you should work through the earlier sections of this guide.

What to do if you cannot remove read-only mode

If none of the above steps work, the file may be corrupted, or your user account may not have permission to edit files in that location. Try saving a copy of the file with a new name in your Documents folder using File > Save As. If that works, the original file or its location was the problem. If saving a copy also fails, the file itself may be damaged — you may need to ask whoever created it to send you a fresh copy.

If you are on a work computer, your IT department may have restricted your ability to edit files in certain folders. Contact them to ask whether those restrictions can be lifted or whether you should store your files in a different location.

Frequently Asked Questions

Can I edit a read-only file without removing read-only mode?

Yes. While the file is open in read-only mode, make your changes as usual. When you try to save, Excel will ask whether you want to save a copy. Click Yes and give the file a new name. This creates an editable copy with your changes. You can then manually merge those changes into the original file later if needed.

Why does my file keep opening read-only even after I unchecked the property?

The file is likely stored in a protected folder. Move it to Documents or Desktop and try again. If it is on OneDrive or SharePoint, wait for the sync to complete or read a local copy. If you are on a work computer, your IT department may have restricted editing in that location.

What happens to my changes if I edit a read-only file?

Your changes are not lost. Excel keeps them in memory and offers to save them as a copy when you close the file. You can accept that offer and save them under a new name, then manually update the original file later. Alternatively, you can discard the changes and start over once the file is unlocked.

Does removing read-only mode affect other people's copies of the file?

No. Changing the read-only property on your copy affects only your copy. If the file is shared on OneDrive or SharePoint, other people's copies are separate. If someone else has the file open, they will not see your changes until they close and reopen it.

Can I prevent a file from opening in read-only mode in the future?

Store files in editable locations like Documents or Desktop rather than protected system folders. If you receive files via email, save them to your computer before opening them. If you share files with others, use OneDrive or SharePoint so everyone works on the same version instead of separate copies.