Click on apply and ok. Information moves quickly with modern technology. For stronger protection, require a password to save changes. Now this page will show three ways to. Unfortunately, none of that has worked.
Step 1: Open the Excel 2016 workbook. Uncheck this to unlock it. Now the Confirm Save As dialog box comes out. I have a user that just recently received a new lease laptop. In this case, to disable read-only, do as follows. To open the file as just read-only, click on the Read Only option.
When you reopen the workbook later, a warning dialog box will pop out and tell you the workbook is read-only as below screenshot shown: Save a worksheet as read-only If you want to protect a worksheet from being modified, you can save this worksheet as read-only by protecting it easily. Best bet would be to do a save as. If you click on Tools, you should see a dropdown menu. Save As dialog box will appear again. It seems you cannot do any changes on it, but you can save the read-only excel file as another one to remove modify password. The file will be opened and you will not see the Read Only anymore.
There are several possible reasons for an Excel worksheet to say it is Read Only. Difference Between Locked and Read-Only The two ways to lock and unlock the worksheet can be confusing. If you want to save the workbook, you need to save the workbook with a new name or in a different location. Once it is unlocked, reopen the file in Excel to work on it. That means the user will be able to edit or update the file.
If so, this is marked as final, as you will see when you hover on that icon. Save the Read-only file with Password In our previous steps, you have seen we have shown you how to make an Excel file read-only. Thanks for all of your help. Try these two alternative methods to fix your problem. Please do not change them. Also, step 2 ensures that the read only message does not appear when the file is opened this avoids confusion for the operators using it.
Step 3: In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options. Click on the Read Only button to open the file as read-only. Nobody can modify these worksheets until they are unprotected by a correct password. If you open a spreadsheet that another user already has open, there is a message advising that the spreadsheet is in use and providing options for viewing the spreadsheet. The reason is you probably don't have permission to read and write. You might need to save it as another file name if you have already named the document. Step 1: Open the Excel 2016 workbook.
If you know the password that protect worksheet and workbook, remove read only in excel file would be so easy. But you also might not want them to change data, using it for review only. But I think some options you have used to set excel workbook read only, would be able to remove this setting always. I'm wondering if this has anything to do with what's going on. This is a problem if you want nobody can edit your file. 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.
Uncheck all options there to disable. Hi All I have a file that is saved as read only using the below steps to achieve this. If someone could lend me a hand in trying to figure this out, I would really appreciate it. 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. Then when trying to save it, the Read-Only message will pop up again. Such as prevent inadvertent erasure or modification of formulas or other data on the Excel file.