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

Excel opens a file in read-only mode when the program detects that you should not be able to edit it — either because another person has it open, because the file itself is marked read-only, or because you opened it from an email or a protected location. When this happens, you see a yellow banner at the top saying "Read-Only" or the title bar shows "[Read-Only]" next to the filename. You cannot save changes to the file while in this mode.

The fix depends on why the file is read-only in the first place. If someone else has the file open, you need to wait or ask them to close it. If the file is marked read-only on your computer, you change a single setting. If you opened it from email or OneDrive, you may need to save a copy to your computer first. Below are the steps for each situation.

Key Takeaways

  • A yellow banner at the top of Excel means the file is in read-only mode, and you cannot save changes until you turn it off.
  • If another person has the file open, Excel will tell you their name and you must wait for them to close it or ask them to do so.
  • If the file is marked read-only on your computer, right-click the file in File Explorer, choose Properties, uncheck "Read-only", and click Apply.
  • Files opened from email or OneDrive may open in read-only by default; save a copy to your computer and open that copy instead.
  • If you see "Edit Anyway" in the banner, clicking it will let you edit the file, but changes may not save if someone else has it open.

Check if someone else has the file open

When another person has the file open at the same time, Excel displays their name in the read-only banner at the top. The message reads something like "This file is locked for editing by [Name]" or shows a notification that the file is in use. This is Excel's way of preventing two people from making conflicting changes to the same file at once.

If you see a name in the banner, contact that person and ask them to close the file. Once they close it, close Excel completely and reopen the file. It should no longer be read-only. If the person is no longer at their desk or you cannot reach them, you can click "Edit Anyway" in the banner to make changes, but those changes may not save properly if they still have the file open.

Remove the read-only mark from the file itself

Files can be marked as read-only at the file level, which prevents anyone from editing them unless they change this setting first. This often happens when you download a file from the internet or when someone intentionally locked the file to prevent accidental changes. To check and remove this mark, you need to access the file's properties in Windows.

On Windows: Open File Explorer and navigate to the folder where your Excel file is stored. Right-click the file and select Properties. In the Properties window, look for a checkbox labeled "Read-only" near the bottom. If it is checked, click the checkbox to uncheck it. Then click Apply and OK. Close the Properties window, then open the file in Excel again.

On Mac: Open Finder and locate your Excel file. Right-click the file and select Get Info. In the window that opens, look for a section called "Sharing & Permissions" at the bottom. Click the lock icon if it is locked, then find your username in the list and change the permission from "Read only" to "Read & Write". Close the window and open the file in Excel again.

Save a copy if the file came from email or OneDrive

Files opened directly from email attachments or from OneDrive sometimes open in read-only mode as a safety measure. Excel does this to protect the original file in case you make changes you do not want to keep. If you want to edit the file, you need to save a copy to your computer first.

With the file open in Excel, go to File in the top left corner and click Save As. Choose a location on your computer — your Documents folder or Desktop works well. Give the file a new name or keep the same name, then click Save. Close the file and open the copy you just saved from its new location. This copy should open in edit mode, not read-only.

Use "Edit Anyway" if you need to make changes right now

If you see a yellow banner at the top with an "Edit Anyway" button, clicking it will unlock the file for editing immediately. This is useful when you need to make a quick change and cannot wait for someone else to close the file or when you want to override the read-only setting temporarily.

Keep in mind that if another person has the file open, your changes may not save correctly or may overwrite their work. Use "Edit Anyway" only when you are sure no one else is editing the file, or when you have already saved a copy for yourself. After you click "Edit Anyway", the banner disappears and you can edit and save normally.

Check if your file is protected by a password

Some Excel files are protected with a password to prevent editing. This is different from the file being marked read-only — the file itself has an extra layer of security. If you see a message saying the file is protected or password-protected, you will need the password to turn off protection.

If you know the password, go to File, then Tools (or Review on some versions), and look for an option like "Unprotect Sheet" or "Unprotect Workbook". Click it and enter the password when prompted. If you do not know the password, you cannot remove the protection yourself — you will need to contact whoever set it up and ask them to remove it or provide the password.

Frequently Asked Questions

What does the yellow "Read-Only" banner mean?

The banner means Excel has locked the file against editing. This happens when another person has the file open, when the file is marked read-only in Windows or Mac, or when you opened it from email or OneDrive. The banner tells you why and usually offers an "Edit Anyway" button if you want to override it.

Can I edit a file if someone else has it open?

You can click "Edit Anyway" to make changes, but those changes may not save correctly if the other person is still editing. The safest approach is to wait for them to close the file, or to save a copy to your computer and edit that copy instead while they work on the original.

Why does my file open in read-only when I download it?

Windows marks files downloaded from the internet as read-only by default as a security measure. To fix this, right-click the file in File Explorer, select Properties, uncheck "Read-only", and click Apply. Then open it in Excel again.

If I click "Edit Anyway", will my changes save?

Your changes will save to your computer, but if another person has the file open at the same time, there is a risk of conflicts or lost work. Only use "Edit Anyway" when you are certain no one else is editing the file, or when you have already saved your own copy.

How do I know if a file is password-protected?

Excel will show a message saying the file or sheet is protected when you try to edit it. If you see this message, you need the password to unlock it. Contact whoever created the file if you need the password removed.