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

Excel opens a file in read-only mode for one of three reasons: the file itself is marked read-only in Windows, the file is stored on a read-only location (like a CD or a locked shared drive), or Excel detected a problem when opening it and is protecting you from accidentally saving over a corrupted version. The fix depends on which one is happening. Most of the time, you can unlock the file in seconds by clicking a single button in Excel itself.

When a file opens read-only, you will see a yellow banner at the top of the spreadsheet that says "Read-Only — This file is read-only. To modify it, you need to enable editing." A button labeled "Enable Editing" sits on the right side of that banner. Clicking it is the fastest way to unlock the file if Excel is the only thing preventing changes.

Key Takeaways

  • If you see a yellow "Read-Only" banner in Excel with an "Enable Editing" button, click that button to unlock the file when ready.
  • If the file is stored on a CD, a read-only USB drive, or a locked network folder, you must copy it to your Documents folder or Desktop before you can edit it.
  • To remove the read-only mark from a file in Windows, right-click the file, select Properties, uncheck "Read-only" under Attributes, and click explore.
  • If the file is shared in OneDrive or SharePoint and you do not have edit permission, ask the owner to grant you editing access.
  • If Excel itself locked the file for safety, the "Enable Editing" button will unlock it, but save the file with a new name to avoid overwriting a potentially damaged original.

Click "Enable Editing" if the banner appears in Excel

Open the file in Excel. If a yellow banner appears at the top saying "Read-Only — This file is read-only. To modify it, you need to enable editing," click the "Enable Editing" button on the right side of that banner. The file will unlock when ready, and you can edit and save normally.

This is the most common scenario. Excel is not preventing you from editing because the file is damaged or locked at the Windows level—it is just being cautious. Once you click "Enable Editing," the banner disappears and the file behaves like any other spreadsheet.

Copy the file to your computer if it is on a read-only location

If the file is stored on a CD, a read-only USB drive, or a network folder that your account does not have write permission to, you cannot edit it in place. You must copy it to a location you control, such as your Documents folder or Desktop.

Right-click the file in File Explorer, select Copy, navigate to your Documents folder or Desktop, right-click in the empty space, and select Paste. Open the copied file in Excel. It should no longer be read-only. If it still is, move to the next section to remove the read-only mark in Windows.

Remove the read-only mark in Windows Properties

If the file itself is marked as read-only in Windows, you must remove that mark before Excel will let you edit it. Right-click the file in File Explorer and select Properties. A window will open showing file details.

Near the bottom of the General tab, you will see a section called Attributes. Look for a checkbox labeled "Read-only." If it is checked, click it to uncheck it. Then click the explore button at the bottom right of the Properties window, and click OK. The read-only mark is now removed. Open the file in Excel—it should unlock.

If you do not see the Attributes section, scroll down in the Properties window. On some versions of Windows, it appears below the file type and size information.

Check file permissions if the file is on a shared drive or cloud storage

If the file is stored in OneDrive, SharePoint, Google Drive, or a shared network folder, the read-only status may be enforced by the folder's permission settings, not by the file itself. You may have view-only access instead of edit access.

For OneDrive and SharePoint files, open the file in Excel, and look for a "Share" button in the top right corner. Click it and check whether your name appears with "Can edit" or "Can view only" next to it. If it says "Can view only," you do not have permission to edit. Contact the person who shared the file and ask them to change your permission to "Can edit."

For files on a network folder, right-click the file, select Properties, click the Security tab, and look at the permissions listed under your username. If you see only "Read" and "Read & Execute" but not "Modify" or "Write," you do not have edit permission. Ask your IT department or the folder owner to grant you write access.

Save with a new name if Excel locked the file for safety

Occasionally, Excel locks a file in read-only mode because it detected a problem when opening it—a corrupted section, an unrecognized format, or a file that was not closed properly the last time it was edited. In these cases, clicking "Enable Editing" will unlock the file, but you should not save over the original.

After clicking "Enable Editing," go to File menu, select Save As, and give the file a new name (for example, add the date or "fixed" to the end of the filename). Save it to the same folder. This preserves the original file in case something goes wrong, and you now have a working copy you can edit freely.

If the file continues to have problems after you save it with a new name—formulas breaking, data disappearing, or Excel crashing—the original file may be genuinely corrupted. In that case, restore from a backup if you have one, or rebuild the spreadsheet from scratch if the data is critical.

When to call for help

If you have tried all the steps above and the file is still read-only, the problem is likely a permission issue that requires your IT department or the file owner to fix. This happens most often with files on company networks or shared cloud accounts where access is controlled centrally.

Before you contact them, have the file path ready (right-click the file, select Properties, and copy the location shown under "Location"). Tell them whether you own the file, whether you have edited it before, and whether other people can edit it. That information will help them diagnose the problem faster.

Frequently Asked Questions

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

Yes. You can open a read-only file, view it, copy data from it, and print it without unlocking it. You just cannot save changes back to the original file. If you want to save your own version with changes, use File > Save As and give it a new name.

What if I click "Enable Editing" and nothing happens?

The file may be locked at the Windows level or stored on a read-only location. Skip to the "Remove the read-only mark in Windows Properties" section, or check whether the file is on a CD, USB drive, or network folder you do not have write access to. If neither applies, restart Excel and try again.

Does removing read-only mode delete anything from the file?

No. Removing read-only mode only changes whether you can edit the file going forward. It does not alter the data, formulas, or structure of the spreadsheet. The file contents stay exactly the same.

Why does my file keep opening in read-only mode even after I unlock it?

The file is probably stored on a read-only location or your account does not have write permission to the folder. Copy the file to your Documents folder or Desktop instead. If it still opens read-only there, check the file's Properties in Windows and uncheck the "Read-only" checkbox under Attributes.

Can I change a file from read-only on a Mac?

Yes, but the steps are different. Open the file in Excel, click File, select Properties, and look for a "Read-only" checkbox. Uncheck it and save. If that does not work, open Finder, right-click the file, select Get Info, and uncheck "Locked" under the General section.