How to Make Excel File Read Only

If you have been working with Microsoft apps (such as Excel, PowerPoint, or Word), I am sure you have encountered files that are read-only.

What a read-only file means is that it’s only supposed to be read, and not be edited.

So if you make a file read-only (and the user opens it as a read-only file), they won’t be able to make any changes to the original file.

In this tutorial, I will cover how to make an Excel file read-only, all the options a user gets when opening a read-only file, and how to remove the read-only property from an Excel file.

Create Read Only Excel File

You’ve probably created a lot of Excel files that you need to share with other users, but don’t want it to be changed. 

If you make a file read-only, other users will have access to it, but all changes will have to be saved in the new file. Therefore, the original file will be untouched.

This way you can be sure that your file will be the same despite sharing it with other colleagues (especially if that file is on a network drive where multiple people can change it).

Let’s now see how to save an Excel file and protect it as read-only. This option can be activated during the saving of the file.

  1. In the ribbon, go to the File tab.
Click the File tab
  1. In the menu on the left side, choose Save As.
Click on Save as
  1. Choose Browse.
Click on Browse
  1. In the Browse window, click on Tools and choose General Options.
Click on General Options in the tools drop down
  1. In the General Options window, you need to check Read-only recommended and click OK.
Check Read Only Recommended
  1. Now you’re back in the Browse window, and just click Save button to save the file and read-only settings.
Save the file as read only

Finally, you saved your file as a read-only Excel document.

Let’s now see what happens when you open the file and try to edit it.

One thing you need to remember is that when you make a file read-only, the user can still open the original file and make changes to it (they just need to decline the option to open the file as read-only). So if you’re doing this to make sure no one changes the original file, be informed that this is not a fool-proof way.

What Happens when You Open a Read Only File?

If you try to open the previously saved read-only file, you will get the following prompt:

Read Only opening prompt

Excel notifies you that the file you’re opening is read-only and asks you if you want to open it as read-only or not.

Possible answers here are:

  • Yes – if you select Yes, the file will be opened in the read-only mode, which means that you will have to save it as new file (with a different name) in order to save your changes
  • No – if you choose No, the file will open as a regular Excel file (not in read-only mode), and you’ll be able to make changes to the original file and save it
  • Cancel – if you choose to cancel, it will close the file

As you can conclude from the previous explanation, the read-only feature doesn’t actually protect your workbook.

This option just notifies a user that you don’t want the original file to be changed. However, if a user doesn’t choose to open as read-only, the file can be changed normally.

So, if you want to be sure that your file is secured and not changed, you need to password protect it. On the other side, the read-only option is just a notification for other users.

One scenario where making the file read-only helps is when you don’t want yourself or any other user to make any changes in the file inadvertently. So if you only want to read the file (and it has been saved as read-only), it’s better to open it as read-only. This way, even if you make some changes and hit the save button, it will save it as a separate file.

Changing a Read Only File

If you select yes when opening a file (which means that you opened the file as read-only), you will have to save it as a new file after making any changes.

When you open a read-only file, you can see at the top of the file (next to the name) that the file is read-only.

File name shows Read-Only
  1.  Once you’re done with the changes and want to save the file, click the save icon or press CTRL + S on the keyboard to save the file.
Click on the Save icon in the Quick Access Toolbar
  1. The warning message pops up, with the information that you can’t change the read only file and have to save it as a new file with a different name or in a different location.
  1. When you press OK, the Save As window will appear. Here you have to give a new name to the file or go to Browse and select a new file location to save it.
Click on Copy of Read Only file

As a result, the original file remains unchanged, while the changes you made are saved in a new file that you created.

Also read: Microsoft Excel is Waiting for Another Application to Complete an OLE Action – Fix!

Removing Read-Only Option from a File

If you don’t need your file to be read-only anymore, you can easily remove a read-only option from the file and make it editable again.

In order to do this, you have to follow similar steps to creating a read-only file.

  1.  First, you need to open the file as editable, not read only. When you open the read only file, Excel will ask you if you want to open it as read only, and you have to click No.
Select No on Read-Only file opening prompt
  1. In the ribbon, go to the File tab.
Click on File
  1. In the menu on the left side, choose Save As.
Click on Save as
  1. Choose Browse.
Click on Browse
  1. In the Browse window, click on Tools and choose General Options.
Select General Options in tools drop down
  1. In the General Options window, you need to uncheck Read-only recommended and click OK.
Uncheck Read-only recommended
  1.  Now you’re back in the Browse window, and just click the Save button to save the file.
Click on Save

Finally, you saved your file without the read-only feature. If you open it again, you will be able to change it and save, without any restrictions or warnings.

Also read: How to Edit Document Properties in Excel

Conclusion

As you saw in the article, making an Excel file read-only, can help you to prevent unwanted changes to your file.

However, this feature can’t stop a user from changing your file. It will only give a warning, that a file is read-only, and shouldn’t be changed.

You must keep in mind that a user can always choose to ignore a warning. Furthermore, the file doesn’t need to be opened as a read-only and in that case, it can be easily changed and saved.

So, if you need to protect your file from changes and want to be sure that it won’t be changed, you need to use password protection.

Every read-only file has the information next to the name on the top when it’s opened, that you’re working in a read-only file. When changing this kind of file, all changes have to be saved in a new file with a new name, or in a different location on a computer.

If you want to remove a read-only attribute from a file, you need to open it not as a read-only, but as an editable file. This way, you can use the same steps as for creating a read-only file to remove this feature. All of this, you need to do during the saving of a file.

I hope you found this tutorial useful!

Other Excel tutorials you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment