The only problem with checking this out is you need to check for the process on all the computers that had accessed that file Krystal wrote: I have just tried opening it via remote desktop logging in as the last user that modified the document and it opens fine and I can save changes but when I try open it from my computer it is still saying read only. You can check your free space on OneDrive by clicking the OneDrive icon in the notification center and choosing Manage storage, or you can go to , sign in, and note the amount of used space in the lower left of the screen. Are the file properties set to read-only? This is also commonly the case with email attachments or files you've downloaded. Hoping this helps you solve your Read only problem. I checked all of the Excel workbook security options, and nothing is set to open by default as Read-Only. Something in my computer still recognizes that specific file name as Read Only.
This was working as intended about a year ago, but I believe there may have been updates to Office 365. It will create a copy of each worksheet listed in a new workbook, then save and close the workbook. In some cases, this is for added security, such as when you are opening files from the internet, and other times, it can be due to a setting that can be changed. I read the title and immediately thought this could be the issue, good catch Bryce. 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. Right-click and select Properties and there should be an 'Unblock' button, just click it. I have to keep performing a save as with a new file name to get by the issue.
If open the Excel file as read-only, and you edit it on the read only mode, you won't be able to save it as the same Excel file name on the same location. Sometimes, like when opening an email attachment, it will open in Protected View by default, but not when opened from the server. Select For Each CurCell In Selection If lastCellFx. About the Author Based in Southern Pennsylvania, Irene A. For me the problem was bt different and simple. I've checked all the check boxes for Read only and they aren't checked, not too sure where to go. She holds a Bachelor of Arts in English from Shippensburg University.
When I removed the slash from the filename using the finder , the Excel file then opened normally. Let us know if you need further assistance. I wasted a lot of time on it. Here is a screen cap of what you may see all my file names, and user names are blocked out along with my domain info, sorry buddy. · Open Word and check if it works.
Properties seems pretty useless to me. If you found this article helpful, and especially if you didn't, please use the feedback controls below to let us know how we can make it better. We get this issue every here and there and the only thing that fixes it is a reboot of our file server. It sure sounds as if someone has it open. · Now try to save the document, re-pen the saved document and check.
When I removed the slash from the filename using the finder , the Excel file then opened normally. I don't want to edit the file, but I want to be able to perform calculations while the file is open, and then close it without worry that I altered it. 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. Hi, I work on a shared drive and work with communal files constantly. If you like the attachment preview feature, use the Edit message method.
Get which will help you to remove the read-only password in two seconds. This is achieved in six steps. Note: this disables preview for all attachments. So as someone once said. The truth is, you are not able to fully protect your Excel file with just Excel. Attempts to open these files will bring up the Install. Add passwords if you want Excel to prompt for a password before allowing a user to open or modify the workbook file.
Applies to Excel 2010, 2013, 2016. Is there any way to get the file to open in an editable mode through the macro, or at the very least allow the Enable Editing option to appear for each workbook? Let me assist you with the issue. Hope this helps someone else. Check to see that the 'Read-Only Recommended' hasn't been selected by accident. The next time you need to edit an attachment and save the changes back to the message, open the email message, click the Edit Message button then open the attachment.