You can instead lock it through sharing and permissions located at the bottom of the Get Info box. 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. If don't want to restrict the Excel file with password any more, you can remove it by this way: 1. I was thinking and writing in terms of the file or its icon in a Finder window, not a menu option with the file open. 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. When I do as I suggested to you, for the same file from Finder, in the Get Info window I can change the Read Only to Read and Write. In that way, the read-only file can be opened in editable mode by all.
And then clear the check box next to Read-only recommended. I earn a small commission if you buy any products using my affiliate links to Amazon. Download a tool called , install it on computer. Double-click on the Excel file, and enter the restrict editing password for write access. Before you make the change it is probably a good idea to copy the current path for where Word auto recovery files are kept. That's the Mac way, not the Microsoft way. Sharing and Permissions Now that you can edit and manipulate the data in the worksheet, you might want to share it with your team or colleagues.
So, did you try that route? In that case, you can make your file read-only with a password. Well, one of many things. This does, however, prevent you from being able to change anything else. Step 1: Open the Excel 2016 workbook. I want to restrict my users from modifying the file. Try to open the file. On the bottom of Save As dialog, click on Tools, and select General Options.
Step 1: Open the Excel 2016 workbook. Still stuck in this issue. Then the read-only mode in the Excel 2016 workbook can be disabled. When you see info file It will be changed to read only. In this dialog box, click on the Read-only recommended check box. I wasted a lot of time on it. Case 1: If the Excel 2016 workbook is just marked as final to let readers to know it is final and read-only, to disable the read-only mode, just need to open the Excel 2016 workbook and then click the Edit Anyway button on the yellow warning appeared at the top of the workbook.
I input a password in the Password to modify field. What can I do to remove the warning? For stronger protection, require a password to save changes. Way 3: Excel file restricted with editing password When you wanting to open the Excel file that is restricted with modify password, you will be prompted to enter password for write access, or open the Excel file as read only. Does anyone have any kind of help for me? Locate the file or folder on which you want to take ownership in windows explorer 2. I'm using Excel from Microsoft Office 2011 for Mac, and while working on a spreadsheet yesterday, the autosave function crashed.
On this case, you still be able to edit this Excel file, but can't save it as the same name on the same location. 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. How to remove read only from excel file when it is marked as final? All my data were on D drive. If you want to modify the Excel file, here will show you to make it editable. Way 2: Excel file is in read-only recommended When you open a read-only recommended Excel file, you will be prompted to open this Excel file in read only mode, unless you need to make changes to this Excel file.
If you know the password that protect worksheet and workbook, remove read only in excel file would be so easy. I have no issues with word, ppt. I will eliminate the dashes on the problem files only and see how it goes, sure would be nice to find the root of this problem. Rightclick on the partition, folder or file s and select Properties. Editing the saved workbook, before initial closure, may expose additional bugs — one of which is shown at end of this answer. The file will be opened and you will not see the Read Only anymore. This is what I love about Microsoft.
After selecting a folder, you will get the Save As dialog box as the picture below. Now, I want to make this file Read Only. For the file that I opened, both Read Only and Hidden are not selectable. Go to the location of the Excel file, you will find a new Excel file with the same name but marked as Unprotected. You see there are two password fields in the dialog box. You would need to ask the original file creator to resend it after updating your permissions.