How to change a read only file in excel

how to change a read only file in excel

Set or clear read-only status

Sep 25, In this case, to disable read-only,have a look: Open the Excel workbook. Type the password for write access and click OK. Click File -> Save As, select one location where you will save this document. The first step in how to make a file read only is to enable the setting. 1: Go to the File tab and select Save As. 2: Select Browse. 3: Click on the Tools dropdown at the bottom of the Save As dialog box. 4: Select General Options from the list.

If you do not like without your permission no one can edit or update your Excel file, you can make your Excel file read-only. In this article, I will teach you the whole process and also show you how you can disable the read-only option how to change a read only file in excel an Excel file. In the image above, select a Folder where you want to save your Excel file. After selecting a folder, you will get the Save As dialog box as the picture below.

In the Save As dialog box, you will what is cephalexin monohydrate used for Tools option at the bottom right corner of the dialog box. Click on it. A drop-down will appear. You will find 4 options in the drop down. Select General Options. See the picture below. Click on the General Options. General Options dialog box will appear as the picture below. In this dialog box, click on the Read-only recommended check box.

It will be selected. Click OK. Save As dialog box will appear again. Just click on the Save button and fole the file. When you click on the file to open it, Microsoft Excel dialog box will pop up with excrl message like the picture below:. If you do not want to open the file as read-only, you will select the No button. If you select the No option, the file will be opened in editable mode. That means the user will be able to edit or update the file.

In our previous steps, you have seen we have shown you how to make an Excel file read-only. In that how to become a hare krishna, the read-only file can be opened in editable mode by all. This is a problem if you want nobody can edit your file. In that case, you can make your file read-only with a password. It means: to make the read-only file editable, the user s must have the password.

When we were making our Excel file read-only in our previous discussion, you had seen the General Options dialog box as the picture below.

You see there are two password fields in the dialog box. So, I will not apply any password in the Password to open gow. I want to restrict my users from modifying the file. So, I will apply a password in the Password to modify field. When you click on the file for opening, Password dialog box will pop up.

The dialog box has some information for onnly. It says: the file is reserved by someone. And you have to enter the password if you want to edit the file.

To open the file as just read-only, click on the Read Only option. In this mode, you will not be able to edit or update the file. You will handle two types of read-only files. One could be just made read-only and another one could password protected.

If the read-only excel file is made without any password, you can easily disable the read-only from the file. Select the No option. The file will be opened and you will not see the Read Only anymore. You cannot directly disable the read-only option from an Excel file if the file is password protected. So, when you click on a read-only Excel file password protected to open it, Password dialog box will appear. Click on the Read Only button to open the file as read-only.

Now if you make any change in the read-only workbook, you will not be able to save the workbook. If you want to save the workbook, you need to save the workbook with a new name or in a different location. So, you go to the Save As option and save the file with a new name or new location if you want to excep the file name same as the read-only file.

So, these are the ways to make an Excel file read-only and disable read-only from a read-only Excel file. Do you any other ways? Share in the comment box. We provide tips, how to guide and also provide Excel solutions to your business problems. I earn a small commission if you buy any products using my affiliate links to Amazon.

Contact Privacy Policy. Welcome to my Excel blog! It took me dile time to chqnge a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Stay tuned! We will be happy to hear your thoughts.

Leave a reply Cancel reply. About ExcelDemy. Follow Us.

Way 1: Excel file is made to read only by marked as final

Open the Finder and select the workbook you want to protect. On the File menu, click Get Info. On the General pane, select the Locked check box. Clear the read-only status of a workbook. Click the Toggle Read Only button for the first time, active workbook switches to read only mode; click the Toggle Read Only button once more, active workbook restores editing mode.

Sometimes we may have an Excel workbook that would be sensitive to changes. I have an Excel file with some important functions. How can I share this file with my clients without allowing them to make changes to it? In this case, it will be necessary to protect the workbook from any changes intentional or otherwise by other users that have access to it. We may still want to allow a user to make changes and save those with a new filename or to a different location. Got a different version?

No problem, you can still follow the exact same steps. However, we want to make sure that any changes made by other users do not get saved to the original file. Instead, these users will be forced to rename the file or to save it to a different location. This updates the metrics for the stakeholders that use the report.

Furthermore, it still allows other users to make changes but ensures they can only do so by renaming the file or saving it to a different location than the original file. For instance, Jake, who reached out to us and asked:.

Jake Kurtz. Kasper Langmann , Co-founder of Spreadsheeto. What do you want to learn? How to create a read-only file. How to remove read-only from a file. We now need to share the updated report to users that need the new data and metrics. So, there it is.

2 thoughts on “How to change a read only file in excel

Add a comment

Your email will not be published. Required fields are marked *