Your workbook is read-only now. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended. I just know that I am not the only being on the planet who wants to do this. Clear the password from the text box next to Password to modify. From then on, the copied Excel file would be not read-only and could be used instead of original one.
In this post, we will explore some of the options available. Step 5: When you are back to the Save As dialog, click Save to save the workbook. After selecting a folder, you will get the Save As dialog box as the picture below. Close the current Word document. Click on the General Options. When you try opening the file, you will receive a message box that says that the file should be opened as read-only unless you need to save changes to it.
I input a password in the Password to modify field. It is only when I try and access it from the shared folder from the other computer. Let me know if you have any ideas. And you have to enter the password if you want to edit the file. In this mode, you will not be able to edit or update the file. Now in this article, I will list several possible cases that make your workbook and worksheet read only and introduce how we can do to remove read only status from Excel file. One was created with 2007 read only-perfect and the latest with 2010 which i have to lock so nothing happens to it.
Now cells in the locked range are read-only now. It is only one computer sharing with one other computer. I am just trying to narrow it down a bit. To change that, drop the last True after. So I want to have most people open it as read only and two of us use a password to edit the same spreadsheet. So, you go to the Save As option and save the file with a new name or new location if you want to keep the file name same as the read-only file.
In some cases, you may want to send someone a spreadsheet with data but you also want to ensure that he doesn't accidentally or intentionally edit it, so that the numbers remain accurate. You will receive a warning box that says that the file is a read-only and so on. If you know the password that protect worksheet and workbook, remove read only in excel file would be so easy. Step 5: Click the Save button in the Save As dialog box. Excel and Read Only Spreadsheets You can have Excel make a spreadsheet in read only format for others, so that people can read its contents but not edit them, or you can enforce other content restrictions. But read-only mode could be removed or disabled as you wish anytime when you want to edit excel file? I want people to be able to open, look-at and print the documents but not change them.
Usually, if you share an Excel spreadsheet with someone, that person is able to freely edit the spreadsheet. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window. Now you have been able to edit excel file and make any changes to worksheet or workbook. The remove protection in word document does not work either. Any way the read-only versions can be updated automatically or the users can be advised the changes have been made and to refresh? If an author has to protect it from being modified by others but now you want to remove the read-only mode, read this page to learn based on the three cases. Try to open the file. Otherwise, you just could let excel file read-only all the time.
In this case, to disable read-only, do as follows. I have also opened a document from local hard drive and that opens and resaves with no problems. You might need to save it as another file name if you have already named the document. Then others only can open this Excel workbook in a read-only state. Download a tool called , install it on computer. If you want to save the workbook, you need to save the workbook with a new name or in a different location. Does this issue occur only with the shared file? Now select the cells you want to make them as read only here I select cells of range A1:C18.
This new system is, as Markus says, ridiculous. Please, I beg you, test and confirm steps before posting solutions. My name is Mitch Bartlett. The only place that it informs me is when I actually go to hit save under the original file name. Now if you make any change in the read-only workbook, you will not be able to save the workbook. Also malware bytes and windows defender for antivirus. Making your document a read-only file means that the document can be read or copied but not modified.