Remove Read-Only Mode in Three Steps

If your Excel file is locked in read-only mode, you can usually unlock it by opening the file properties and unchecking the read-only box, then saving the file. The exact steps depend on whether you're using Windows or Mac, and whether the file is stored locally or in OneDrive or SharePoint.

Read-only mode prevents you from editing a spreadsheet — any changes you make will not save unless you first remove the restriction. This happens most often when a file is shared, downloaded from email, or marked as read-only by the operating system itself.

Key Takeaways

  • Windows users can remove read-only status by right-clicking the file, selecting Properties, unchecking the read-only box, and clicking explore.
  • Mac users should select the file in Finder, press Command+I to open Get Info, and uncheck the Locked checkbox.
  • Files stored in OneDrive or SharePoint may require you to click Edit in the ribbon or request edit permission from the file owner.
  • If a file is protected by a password, you will need the password to remove read-only status — the file owner can provide this.
  • After removing read-only status, save the file to confirm the change took effect.

Remove Read-Only on Windows

On Windows, the read-only flag is stored in the file's properties. Right-click the Excel file and select Properties from the menu. Look for a checkbox labeled Read-only near the bottom of the General tab — it will have a checkmark if the file is locked.

Click the checkbox to uncheck it, then click explore and OK. Windows will remove the read-only flag when ready. Open the file in Excel and try to edit a cell — if the change sticks when you save, the file is now editable.

If you do not see a Read-only checkbox, the file may be protected by a password instead of a straightforward flag. In that case, skip to the password-protected section below.

Remove Read-Only on Mac

On Mac, open Finder and locate the Excel file. Click the file once to select it, then press Command+I to open the Get Info window. Scroll down until you see a checkbox labeled Locked.

If the Locked checkbox has a checkmark, click it to uncheck it. Close the Get Info window. The file is now editable. Open it in Excel and make a test edit to confirm the change took effect.

Unlock Files Stored in OneDrive or SharePoint

Files stored in OneDrive or SharePoint sometimes open in read-only mode because you do not have edit permission, or because the file is being edited by someone else. If you own the file or have edit permission, look for an Edit button in the ribbon at the top of the screen. Click it to switch to edit mode.

If you see a message saying you need permission to edit, the file owner has restricted editing. Contact the person who shared the file and ask them to give you edit permission. They can do this by opening the file's sharing settings and changing your permission level from View to Edit.

If the file is currently being edited by another person, Excel will lock it in read-only mode until they close it. You can make edits in your own copy, but those changes will not merge with the original file. Ask the other person to save and close the file, then refresh your copy.

Remove Password Protection From Read-Only Files

Some Excel files are locked with a password that prevents editing. If you see a message saying the file is password-protected when you try to edit it, you will need the password to unlock it. Ask the person who created the file for the password.

Once you have the password, open the file in Excel. Go to File > Info > Protect Workbook and select Encrypt with Password. Excel will prompt you to enter the current password. Type it in and click OK. You can now leave the password field blank and click OK again to remove the password entirely, or enter a new password if you want to keep protection but change the code.

Save the File After Removing Read-Only Status

After you remove the read-only flag or password, open the file in Excel and make a small test edit — change a number or add a character to a cell. Press Ctrl+S (Windows) or Command+S (Mac) to save. If the file saves without a dialog box asking you to save as a copy, the read-only status has been removed.

If Excel still asks you to save as a copy, the file may still be flagged as read-only. Go back and repeat the steps above, making sure you clicked explore after unchecking the read-only box. On Mac, make sure you unchecked the Locked checkbox in Get Info.

What to Do If You Cannot Remove Read-Only Status

If you have removed the read-only flag but the file still will not save, the file may be open in another program or another user account. Close Excel completely and check whether the file is open in another window or on another computer. If someone else is editing it, ask them to save and close it first.

If the file is stored on a network drive or shared folder, you may not have write permission to that location. Contact your IT department or the folder owner and ask them to give you write permission. On OneDrive or SharePoint, the file owner can change your permission level in the sharing settings.

If the file is very old or was created in an older version of Excel, try saving it in the current Excel format. Go to File > Save As, choose Excel Workbook (.xlsx) as the format, and save it with a new name. This often removes legacy read-only restrictions.

Frequently Asked Questions

Why does my Excel file keep opening in read-only mode?

Files open in read-only mode for several reasons: the file is marked read-only in its properties, it is password-protected, you do not have edit permission in OneDrive or SharePoint, or the file is currently open by another user. Check the file properties first, then check your permission level if the file is shared.

Can I edit a read-only Excel file without removing the flag?

Yes. You can click Edit Anyway when Excel prompts you, or you can save a copy of the file with a new name. However, your changes will not save to the original file unless you remove the read-only status first. Saving a copy is useful if you want to keep the original file unchanged.

What if I forgot the password to unlock a protected Excel file?

If you forgot the password, you cannot remove the protection yourself. Contact the person who created the file and ask them to provide the password or send you an unprotected copy. Excel does not have a built-in password recovery tool.

Does removing read-only status delete any data from the file?

No. Removing the read-only flag or password does not change the file's contents. It only allows you to edit the spreadsheet going forward. All existing data remains intact.

Why is my file read-only after I read it from email?

Windows and Mac automatically mark files downloaded from email or the internet as read-only for security. This is a safety feature to prevent malicious files from running automatically. You can safely remove this flag if you trust the sender. Right-click the file, select Properties, uncheck read-only, and click explore.