![]() Please let me know if you have any queries. Hopefully, these methods and explanations will be enough to solve your problems. In the above article, I have tried to discuss guidelines to make an excel workbook read only with a password elaborately. Read More: How to Remove Read Only from Excel (7 Easiest Ways) As a consequence, the excel file will be saved as a new name in an editable and accessible format. Afterward, from the General Options dialog, uncheck the Read-only recommended and click OK.Then choose the General Options from the Save As dialog and press OK.Initially, open the read-only excel file.You can make an excel file editable again by following the below steps. Read More: How to Make a Cell Read-Only in Excel (2 Simple Methods)ĭisable Excel ‘Read-only-recommended’ Option No one can change the original excel file that we have protected with a password. The message in the box ensures that our file is fully protected now. After editing the data, if you click on the Save option, excel will show the below warning box.Here, you may think excel is allowing me to update the value even though the workbook is in a read-only file.After opening the file, let’s consider that I want to modify any sales value. As a result, the file will be opened as usual like in the below screenshot.First, double click the excel file which we made read-only, and enter the password. ![]() Now let’s check whether our file protection works or not. Suppose, you want to open the read-only file that we just have created. Step 4: Open Password Protected Excel File to Check Excel now saves the excel workbook as a read-only file with a password.
0 Comments
Leave a Reply. |