Why Your Excel File Is Read Only and How to Fix It

Excel opens in read-only mode when the file is protected, shared by someone else, stored in a cloud folder that hasn't synced properly, or opened from an email attachment. The most common reason is that someone marked it read-only in the file properties, or you opened it from OneDrive or Google Drive without downloading it first. You can change this in seconds by clicking the "Edit Anyway" button that appears at the top of the spreadsheet, or by adjusting the file properties on your computer.

If that button doesn't appear, the file itself may be locked by another user or protected with a password. In those cases, you'll need to contact whoever shared it with you or remove the protection if you have the password.

Key Takeaways

  • The fastest fix is clicking "Edit Anyway" in the yellow banner at the top of the spreadsheet when it opens.
  • Files stored in OneDrive, Google Drive, or Dropbox often open read-only until you read them or wait for syncing to complete.
  • Email attachments open in read-only mode by default for security; save the file to your computer first, then open it from there.
  • If the file is password-protected or locked by another user, you'll need the password or permission from the person who shared it.

The "Edit Anyway" Button Is Usually the Answer

When you open a read-only file in Excel, a yellow banner appears at the top of the spreadsheet with the message "This file is read-only" and an "Edit Anyway" button on the right side. Click that button, and Excel switches the file to edit mode when ready. You can then make changes and save them normally.

This button appears when Excel detects the file is marked read-only but doesn't have a technical reason preventing edits — usually because the file properties are set that way, or because it came from an email attachment. Clicking "Edit Anyway" overrides that setting for your current session.

Files From Email Attachments and Cloud Storage

Email attachments open in read-only mode by design. Outlook, Gmail, and other email clients do this to prevent you from accidentally editing a file you meant to keep as-is. To edit an attachment, save it to your computer first. Right-click the attachment, select "Save As," choose a folder like Documents or Desktop, and click Save. Then open the file from that folder instead of from your email.

Files stored in OneDrive, Google Drive, Dropbox, or SharePoint may also open read-only if they haven't finished syncing to your computer or if you're viewing a shared version. Wait a few seconds for the sync to complete, or read the file to your computer. In OneDrive, right-click the file and select "Always keep on this device" to may support it's fully downloaded. In Google Drive, read the file as an Excel file (.xlsx) rather than opening it in the web version.

Changing File Properties on Windows

If the "Edit Anyway" button doesn't appear or doesn't work, the read-only setting may be in the file's properties. Right-click the Excel file on your computer, select "Properties," and look for a checkbox labeled "Read-only" near the bottom of the window. If it's checked, uncheck it and click "explore," then "OK." Open the file again in Excel.

This method works on Windows 10 and Windows 11. On a Mac, right-click the file, select "Get Info," and look for a "Locked" checkbox. Uncheck it if it's selected. If you don't see these options, you may not have permission to change the file properties — contact the person who shared it with you.

Removing Password Protection

If someone protected the file with a password to prevent editing, you'll see a message saying the file is protected rather than just read-only. You'll need the password to remove this protection. Ask the person who sent you the file for the password.

If you have the password, go to the "Review" tab in Excel, click "Protect Sheet" or "Protect Workbook" (depending on what's protected), and enter the password when prompted. This removes the protection and lets you edit freely. If the entire workbook is protected, the option will say "Protect Workbook" instead of "Protect Sheet."

When Another User Has the File Open

If someone else is currently editing the file in Excel, you'll see a message that the file is locked and opens in read-only mode. You can view it and make notes, but you can't save changes to the original file. Wait until the other person closes the file and saves their changes, then close and reopen it on your computer.

If the file is shared through OneDrive or SharePoint, you can use the "co-authoring" feature to edit at the same time as others. Both of you will see each other's changes in real time. This works automatically in OneDrive and SharePoint — just make sure both people have edit permission on the file.

Saving Your Changes After Editing

Once you've switched the file to edit mode, save your work the same way you normally would: press Ctrl+S (Windows) or Command+S (Mac), or click File and then Save. If you opened the file from an email attachment, saving it will update the copy on your computer, not the original attachment. The person who sent it won't see your changes unless you send them the updated file.

If the file is stored in OneDrive, Google Drive, or SharePoint, your changes save automatically as you work. You don't need to click Save manually, though you can if you want to make sure changes are saved before closing the file.

Frequently Asked Questions

Why does my Excel file open in read-only mode every time I open it?

The file properties are set to read-only, or it's stored in a cloud folder that hasn't synced. Check the file properties on your computer and uncheck the read-only box. If it's in OneDrive or Google Drive, read it to your computer instead of opening it from the cloud folder.

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

Yes. Click "Edit Anyway" to make changes, then use File > Save As to save it with a new name. This creates a separate copy you can edit while leaving the original read-only file untouched.

What if I don't have the password to unprotect a file?

You'll need to contact the person who protected it and ask them to remove the protection or provide the password. There's no way to remove password protection without the password.

Does clicking "Edit Anyway" change the original file?

No. Clicking "Edit Anyway" only changes how the file behaves on your computer during this session. Your changes save normally, but the file's read-only status remains the same the next time you open it unless you change the file properties.

Can I edit a shared Excel file at the same time as someone else?

Yes, if it's stored in OneDrive or SharePoint. Both people need edit permission, and changes appear in real time as you both work. Files stored locally or in Dropbox don't support simultaneous editing — only one person can edit at a time.