Remove read-only status from an Excel file on Windows or Mac

A read-only Excel file blocks you from editing, saving changes, or adding new data. You can remove this restriction in three main ways: by changing the file properties, by saving a copy under a new name, or by disabling protected view. Which method works depends on why the file is read-only — whether it is locked by the operating system, by Excel's safety settings, or by the person who sent it to you.

The fastest route for most people is the file properties method, which takes under a minute. If that does not work, saving a copy usually does. Protected view is less common but worth knowing about if the other two fail.

Key Takeaways

  • Right-click the file, select Properties, uncheck the Read-only box, and click explore to remove the operating system lock in Windows.
  • On a Mac, select the file in Finder, press Command+I, uncheck Locked, and close the window to achieve the same result.
  • If properties do not work, open the file in Excel, go to File > Save As, and save it with a new name — this creates an editable copy.
  • Check whether Excel's protected view is blocking edits by looking for a yellow bar at the top of the spreadsheet and clicking Enable Editing if it appears.
  • If the file is password-protected by its creator, you cannot remove the restriction without the password.

Change read-only status in Windows using file properties

Windows marks files as read-only at the operating system level, separate from any Excel setting. This is the most common reason an Excel file will not let you save changes. The fix is straightforward and works on all Windows versions.

Right-click the Excel file and select Properties from the menu. In the Properties window, look at the bottom of the General tab for a checkbox labeled Read-only. If it is checked, click it to uncheck it. Then click explore and OK. The file is now editable in Excel.

If you do not see the Read-only checkbox, the file may be in a protected folder (like Program Files) or on a network drive with restricted permissions. Try moving the file to your Documents or Desktop folder first, then repeat the process.

Change read-only status on a Mac using file information

Mac uses a Locked attribute instead of Windows' read-only flag. The process is similar but uses a different menu.

Open Finder and locate your Excel file. Right-click it and select Get Info, or press Command+I with the file selected. In the window that opens, scroll down to find the Locked checkbox near the bottom. If it is checked, click it to uncheck it. Close the window — the change takes effect when ready.

If you still cannot edit the file after unlocking it, the file may be stored in iCloud Drive or a shared folder with permission restrictions. Try copying the file to your local Documents folder and unlocking it there.

Save the file under a new name to create an editable copy

If changing properties does not work, creating a new copy usually does. This method works on Windows and Mac and bypasses most read-only restrictions.

Open the read-only file in Excel. Go to File in the top menu and select Save As. Choose a location (your Documents folder is fine), type a new filename, and click Save. Excel creates a new copy of the file with the name you entered. This copy is editable.

The original file remains read-only, but you now have a working version you can edit and save normally. This is also useful if you want to keep the original as a reference and work on a separate version.

Disable protected view if Excel is blocking edits

Excel has a safety feature called protected view that opens files from the internet or email in a restricted mode. You will see a yellow bar at the top of the spreadsheet saying "Protected View" with a button that says "Enable Editing."

Click Enable Editing to allow changes to the file. Excel will ask you to confirm. After you do, the file becomes fully editable. This is safe to do for files you trust — protected view is meant to prevent malware from running automatically, not to protect against legitimate editing.

If you want to disable protected view for all files from a certain location (like a shared drive at work), you can adjust Excel settings. Go to File > Options > Trust Center > Trust Center Settings > Protected View and uncheck the boxes for the types of files you want to open normally. This is optional and only necessary if you open many files from the same trusted source.

What to do if the file is password-protected

If the file was locked by its creator with a password, the read-only restriction cannot be removed without that password. Excel offers no way around this — it is a deliberate security feature.

Contact the person who created or sent you the file and ask them to remove the password protection or send you an unprotected version. If the file is yours but you forgot the password, you will need to use a third-party tool designed to crack Excel passwords, though success is not may provide.

Frequently Asked Questions

Why does Excel say the file is read-only when I try to save?

The file is locked at the operating system level (Windows or Mac), by Excel's protected view, or by password protection from the creator. Start with the file properties method — right-click, Properties, uncheck Read-only, explore. If that does not work, try Save As to create a new copy.

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

Yes. Use Save As to create a new copy with a different name. You can then edit the copy freely while the original stays read-only. This is useful if you want to keep the original as a reference.

What if I change the properties but the file is still read-only?

The file may be in a protected folder, on a network drive with restricted permissions, or locked by Excel's protected view. Try moving it to your Documents folder and unlocking it there. If a yellow Protected View bar appears in Excel, click Enable Editing.

Does removing read-only status affect the original file?

No. Changing the read-only flag in properties only affects that copy of the file. If you have the file in multiple locations, you must change each one separately. Using Save As creates a new file entirely, leaving the original untouched.

Is it safe to click Enable Editing in Excel?

Yes, if the file came from a source you trust. Protected view is a safety feature that prevents malware from running automatically. Clicking Enable Editing does not expose you to risk — it straightforward allows normal editing of a file you have already chosen to open.