It makes no sense to me as I have never ran across an issue like this before. When I try this on any other computer it opens the spreadsheet without giving the option to edit with a password. I need to be able to edit the spreadsheet and so does one other person. 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 don't want to restrict the Excel file with password any more, you can remove it by this way: 1. Whether you want other people to edit your excel workbook without permission? I just make a fresh installation of win and keep all my other drive partition as it is.
Also I should add I have tried to open a word document from the shared folder and save that as well and I get the same error. When the read-only file is password protected You cannot directly disable the read-only option from an Excel file if the file is password protected. This is certainly more stringent than the non-password option. Unfortunately, since these are files on a shared drive, I don't want to add code to them. So, if you don't want to make change to this Excel file, click on Yes to open it. If you want to save the workbook, you need to save the workbook with a new name or in a different location.
Applies to Excel 2010, 2013, 2016. Also I tried disabling the preview pain as JamminJoe suggested didnt work either. You can delete the old Excel file, and rename the new Excel file name to the old one. Click the Arrow in the Quick Access Toolbar, and select the More Commands from the drop down list. For stronger protection, require a password to save changes.
But if you want to disable excel file read only, removing or recovering excel file password to is necessary at first. There is not an option to do that using SaveCopyAs. Unfortunately, since these are files on a shared drive, I don't want to add code to them. So, I will not apply any password in the Password to open field. I just know that I am not the only being on the planet who wants to do this. Please note that the response by Vijay and the link he provides are about a completely different problem. It saves and overwrites the original file no problem.
Why is my version different than yours? It is the worst thing to happen to me, and that includes my divorce. How to remove the read only password? Why was doing this so incredibly easy in 2003 and so seemingly impossible, now, in the 2010 version? To open the file as just read-only, click on the Read Only option. From then on, when other people open the excel workbook, they will be prompted that the excel workbook should be opened as read-only unless they need to save changes to it. However, this feature does not show in Ribbon. I am just trying to narrow it down a bit. 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. So what I did was copied the information from the hard drive and made a folder for it on the C drive of the main computer, and shared it onto the network.
In the opening Excel Options dialog box, please do as follows: 1 Select the Commands Not in the Ribbon from the Choose commands from drop down list; 2 Click to highlight the Toggle Read Only in the commands list; 3 Click the Add button. Any way the read-only versions can be updated automatically or the users can be advised the changes have been made and to refresh? Once you have workbook open password or successfully remove open password, you would be able to do anything you want on excel workbook. Navigate to each sheet in Workbook you want to keep it read only. Remove Read-Only Restriction Using Windows Explorer You can also remove the read-only status of a file directly through Windows Explorer. Select ThisWorkbook for the file you wish to make Read-only. In this case, to disable read-only, you need to unprotect the sheet by the following steps.
Reopen the spreadsheet, and now you will have the coveted read only function and a password to edit. When the authors or other users who have the authority want to make changes to the Excel file, they can change the Excel file from read only mode to editable mode. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations. Step 5: When you are back to the Save As dialog, click Save to save the workbook. So I want to have most people open it as read only and two of us use a password to edit the same spreadsheet.
I know it is kind of hard without being able to have it in front of you. It is important that the password is only set for modifying the document. 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. Your workbook is read-only now. Is there any way to trigger any other subroutine during change from read-only to read-write mode in xlsm file? But you can save the workbook with new name or in a different location, and then read only is disabled on the new Excel file. Type the following into the Immediate Window and press enter see example in the screenshot above. Restricted by Password Although password restriction is different from being marked as read-only, you won't be able to make edits to your Excel sheet if it's password protected.