So it seems to be an Office behavior instead of an issue. Select For Each CurCell In Selection If lastCellFx. Paul J Hi Paul J, We can't open the temp file to read when the Excel file is opened. If you have to enter a password to open the document then you have not successfully set the document up for Read Only access. You do this by right-clicking on the directory or file and selecting Properties, then the Security tab. Please, I beg you, test and confirm steps before posting solutions.
Your Excel username will appear below. With a single email, a colleague can share a complicated Excel worksheet for you to customize as needed. Now the document will be open for editing by anyone. Click on Security tab 4. The remove protection in word document does not work either. Then expand Share Folders and go to Open Files.
If the file doesn't unlock, you might not have permission to unlock it. When you click on the file to open it, Microsoft Excel dialog box will pop up with a message like the picture below: If you do not want to open the file as read-only, you will select the No button. After selecting a folder, you will get the Save As dialog box as the picture below. We provide tips, how to guide and also provide Excel solutions to your business problems. Enter a password to make Read-only Passwords are not 100% secure Passwords entered using this method are not encrypted and can be cracked.
As a workaround, how about enable Share Workbook in View tab? I just realized this thread was answered and you are having this same problem - probably should have started a new thread and referenced this one as a similar issue but not the same as you have already tried it right? 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? Do you any other ways? Then changes cannot be made to the original workbook. Once you click this, you are able to edit the Excel document. You can change workbook and save changes this time. Feel free to comment and share. Ever since then I have had this problem only a couple of days.
Click on the General Options. Locate the file or folder on which you want to take ownership in windows explorer 2. How to Disable the Read-Only Feature on Your Workbook What if you want to lift the read-only restriction and grant everyone editing privileges? Please understand that as it is an Office related question, it is more recommended to post to Office forum. McAfee particularly had a problem with locking files, and had to exclude those files from being scanned. Then just opening the excel file is a difficult thing, not to say removing read only mode in excel file.
The documents are on my laptop and I only work from a laptop, never a phone. Only after removing protection, can you modify a protected cell or chart. That is encrypting Workbook with password to prevent workbook from opening. Why is my version different than yours? So, I will apply a password in the Password to modify field. Note: a potential issue is conflict as if 2 users are writing in the same time, data may be overwritten.
This, I believe is caused by the file backup systems we use. If you know the password that protect worksheet and workbook, remove read only in excel file would be so easy. I only have guesses as to why that is happening; I don't know for sure. Keep in mind that people may be able to copy data from the spreadsheet to another spreadsheet or file, and then edit it there if they wish to do so. One of the features that we used a lot with the old version of Excel and Word was the ability to password protect a spreadsheet or document from changes, but still allow read only access to the file so the rest of the staff could get information they needed, but not accidentally modify the file. In the image above, select a Folder where you want to save your Excel file.
My comment is that it does essentially do so but there is one thing I do not like. It is the worst thing to happen to me, and that includes my divorce. The next time you open the workbook, it will not open in Read-Only mode, nor will it display the Read-Only restriction box. Memorize the password or store it in a safe place, such as in a secure password manager program. Thanks for your response and a useful suggestion. I see the file tab, then save. It saves and overwrites the original file no problem.
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. When I try this on any other computer it opens the spreadsheet without giving the option to edit with a password. When you will open the file, you will get a dialog box like the following picture. Type the following into the Immediate Window and press enter see example in the screenshot above. But when you save and open this workbook next time, you would find this workbook still recommend you to open it as read only. Set the file to read-only with a Macro By using a Macro, it is possible to set the file to read-only when the file is opened.