Now the workbook is saved as a read-only Excel template. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window. Click Save button in Save As dialog to save workbook and replace the original one. Click Review tab and Protect Sheet in Changes group. Therefore, anybody who really, really wants to could get access to your document. When I try this on any other computer it opens the spreadsheet without giving the option to edit with a 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.
In this article, I will teach you the whole process and also show you how you can disable the read-only option from an Excel file. 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. I will show here two ways to disable the read-only from an Excel file. From the drop-down box, click General Options… 5. Way 3: Set Modify Password to Protect Workbook in Read Only Mode To directly protect workbook from editing, I think the common way is to set a modify password on it. I gave the person an answer. If want to disable read only in Excel, enter password for write access.
To Be Appreciated By Your Boss And Colleagues So That Get A Promotion And Salary Increase. That being said, you should not solely rely on it to secure sensitive data. Right click the sheet tab you need to make cell as read only, and then click View Code from the right-clicking menu. In menu i will select A1. Disabling Read-Only in the Excel file You will handle two types of read-only files.
Similar options are available for other common office software, including Microsoft Word. Here you can use the Protect Worksheet and Unprotect Worksheet utilities of Kutools for Excel to quickly protect or unprotect multiple worksheets or all workrksheets in current workbook with password at the same time in current workbook. Thanks for contributing an answer to Stack Overflow! Click File menu and click Save As to open the Save As dialog box. But when you save and open this workbook next time, you would find this workbook still recommend you to open it as read only. Then just opening the excel file is a difficult thing, not to say removing read only mode in excel file. Are you looking to protect certain cells????? Tips: There is another way you could also protect workbook from editing. Another method is to restrict formatting and editing.
From then on, the copied Excel file would be not read-only and could be used instead of original one. To save changes, you just could create a new copy of the workbook and give it a new name, or save workbook in another location. Why is my outcome different than yours? Case 4: Worksheet and Workbook structure is locked and read only While your excel file is read only and you know it is because worksheet and workbook structure is protected, it will be easy or difficult to disable read only. Step 3: In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options. It means you have disabled read-only in Excel file.
If a user has write access to the folder in which the file is saved they could just save down a version of your file, delete the original file, then save a new version with the same name. If one of the reviewers tries to make changes to a read-only file, the changes can be saved only by giving the document a new name or saved to a new location. Navigate to each sheet in Workbook you want to keep it read only. Surely, read-only excel file could prevent accidental changes on it. But if you want to disable excel file read only, removing or recovering excel file password to is necessary at first.
From the General Options dialog box, click to place a checkmark beside Read-only recommended. But it forces them to resave with a new name. Now every time a user attempts to open the workbook, a pop-up notification box will appear with the following message. To open the file as just read-only, click on the Read Only option. But this is not what i am looking for.
That means the user will be able to edit or update the file. I want to restrict my users from modifying the file. Enter a password to make Read-only Passwords are not 100% secure Passwords entered using this method are not encrypted and can be cracked. This would display the following menu list Click on the Mark as Final menu, the following dialog box would appear. Now, I want to make this file Read Only. When the Excel file is opened as read only, and was made changed, it won't be able to save to the same file name on the same location, but it is able to be saved to another name and another location. If you set a password to open the document the users will not be able to open the file without a password.
Removing the Read-Only feature is an easy process and can be done with just a click of a button. Click on the General Options. Otherwise, you just could open the workbook read only. 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. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing.
But read-only mode could be removed or disabled as you wish anytime when you want to edit excel file? Now select the cells you want to make them as read only here I select cells of range A1:C18. Please can anyone advise if I make changes and save them down, will this update the data in the read-only versions or will the users have to re-open the file to keep checking for changes? One was created with 2007 read only-perfect and the latest with 2010 which i have to lock so nothing happens to it. Now you have been able to edit excel file and make any changes to worksheet or workbook. Way 3: Make an Office 2016 Excel spreadsheet read-only with sheet protection Step 1: Open the spreadsheet. I just know that I am not the only being on the planet who wants to do this. If you don't want content reviewers to accidentally modify your document, you can make the document read only before sending it for review. How to remove read only from excel file when it is marked as final? If you have no idea about how to , following article would tell you several ways that you can use to restrict other people from changing your workbook.