How to remove read only from Excel?

Excel allows users to protect data on various levels, depending on the reason. For example, to avoid data loss, to stop other users from changing formulae, or to maintain a specific format for your data. For collaborative work, Excel also allows users to share an Excel file in “Read-only” mode to restrict editing. Excel will show the following message: “To prevent accidental changes, the author has set this file to open as read-only”.

So, how do you change an Excel file from “Read-only” to edit?

In this article, you’ll learn why an Excel file opens in “Read-only”. You’ll then learn how to remove the “Read-only” mode from an Excel file in multiple ways, including changing from a “Read-only” workbook to an editable Excel file, disabling “Read-only” by unprotecting an Excel workbook or sheet, and how to edit a “Read-only” Excel file by changing its properties.

If the goal is to let people see your data without touching the original file, Sheetgo can send each person a separate copy with only the data they need, whether they work in Excel or Google Sheets, and keep it updated automatically. Along the way, its AI Processor can tidy the data, for example by sorting free-text notes into clean categories.

Why are my Excel spreadsheets opening as read-only?

To remove the “read-only” status from an Excel workbook or sheet, it’s crucial to figure out why it was set in the first place. The 6 main reasons your Excel is showing up as “Read-only” include that it has been “Marked as final”, set to “Open as Read-only Recommended”, password-protected, set to “Read-only” in File Properties, saved in “Protected View”, or the computer antivirus is causing the file to open as “Read-only”.

The Excel file is “Marked as Final”

Excel allows you to save your file as a final draft, i.e. “Marked as Final”, to discourage further editing. When opening a file that has been “Marked as Final”, Excel prompts the message below: “MARKED AS FINAL: An author has marked this workbook as final to discourage editing”.

The Excel file is set to “Read-only recommended”

When an Excel file is set to “Open as Read-only Recommended”, users can’t rename, move, or overwrite the file while it’s open as read-only. More than a data protection method, it serves as a warning message, since you will still be able to save a copy of the file to edit.

The Excel file is in read-only mode

Similar to the previous scenario, the “Read-only” mode will still allow users to edit. However, the warning message will be different, as shown below. The method to remove this is also different.

The Excel file is protected

Although Excel prompts the same “Read-only” message as in the previous scenario, you can check whether the Excel is protected or not by heading over to the “Review” tab. Here, you should see the “Protect Workbook” button active.

Passwords prevent your Excel file from unauthorized access. If you need to remove one, here’s how to remove a password from an Excel workbook.

The Excel file is in Protected View

Opening an Excel file in “Protected View” prompts the following message “PROTECTED VIEW Be careful – files from the Internet can contain viruses. Unless you need to edit, it’s safer to stay in Protected View”. This will stop any file with viruses or malware from affecting your system. Another reason Excel prompts this message is when the filename contains special characters.

In addition to the scenarios seen so far, some antivirus programs open files as “Read-only” to avoid any potential harm or risk. As this will depend on each type of software, we recommend checking your antivirus documentation and Microsoft’s support pages for Excel to find potential solutions.

A file can also open as read-only when someone else has it open. If Excel says the file is locked for editing, even by you, here’s how to unlock an Excel file for editing.

Now that you’ve seen the different scenarios that could lead to Excel prompting the warning message for “Read-only”, let’s see how to remove this mode from an Excel file based on each case.

How to remove read-only from an Excel file?

Let’s now explore how to remove “Read-only” from an Excel file, following the same sequence as before. This way, you can simply head to the section which applies to your situation and follow the steps to resolve the issue.

How to remove read-only from a file “Marked as Final”?

If your Excel file is “Marked as Final”, it will restrict you from editing. To remove the “Read-only” mode in this case, follow these steps.

1. Go to File > Info, on the left-side menu.

2. Click on “Protect Workbook” and select “Mark as Final” from the drop-down menu.

You can now continue editing the Excel file as normal without the “Marked as Final” setting.

How to turn off “Read-only recommended” in Excel?

In this circumstance, you can either open the file to only view or select “Edit Anyway” to make it editable. This is how you can change an Excel file from “Open as Read-only Recommended” to an editable spreadsheet.

1. Go to File > Save a Copy and then “Tools”, to the left of the “Save” button.

2. Select “General Options” from the drop-down list.

3. Click on the “Read-only recommended” box to disable the setting.

As shown in the image above, the file may be protected with passwords. In this case, we recommend reading our article on how to remove a password from Excel.

How to remove the read-only attribute from an Excel file?

The “Read-only” setting can also be set in “File Properties”. To remove “Read-only” from your Excel file properties, simply follow these steps.

1. Go to the folder where you saved the “Read-only” Excel file.

2. Right-click on the file and select “Properties”.

3. In “Attributes”, untick the “Read-only” option to remove it. Then, click Apply > Ok.

How to remove read-only from a protected Excel file?

If your Excel file is in “Read-only” mode because a user protected the file, this is how you can remove this setting.

1. Open your Excel file and go to Review > Protect Workbook. It will prompt you to enter the password to continue. Enter the password and click “Ok”.

The same applies in case someone protected the sheet – simply click on the “Protect Sheet” button. If you have forgotten or don’t know the password, you will need to remove the password from the Excel file.

How to turn off Protected View in Excel?

Although we recommend keeping the “Protected View” feature to safeguard your computer from malware or viruses, you can specify the situations where you want Excel to open in “Protected View”.

1. Go to File > Options.

2. Go to “Trust Center”, on the left-side menu, and select “Trust Center Settings”.

3. Select “Protected View” from the left-side menu and then tick the options depending on your preferences. We recommend keeping the first three options for basic security levels and removing the last two options, if necessary.

Conclusion

Excel offers users a variety of options to protect their dataset, so it’s crucial to understand the level of protection to remove the protection correctly. Recognizing the type of “Read-only” status in an Excel file will save valuable time in figuring out how to remove it.

You should now know how to remove the read-only mode from an Excel file that is “Marked as Final”, in “Protected View”, set to “Open as Read-only Recommended”, protected, or affected by an antivirus.

If you want to know more about removing protection from your Excel files, read our blog article how to remove a password from Excel.

If people only need to see the data, send a PDF copy instead, since they can’t change it in Excel. And if you also work in Google Sheets, the equivalent settings are covered in our guides to permission levels, protecting cells and sheets, and making a Google Sheets file editable.