Thanks when i try to save the original file, it says me to save the new file. In that case, what do you want to do? I know that I have seen the message say a username before but don't know how get this to happen. 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. Spreadsheet Settings Excel spreadsheets and workbooks can be protected to prevent changes. It saves and overwrites the original file no problem.
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. It is not prompting that it is Read Only when another person has it open for editing. This solution is for Mac. 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. Just a quick update and answers to your questions. I know it is kind of hard without being able to have it in front of you. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations.
It is just the excel files in one network share. For the file that I opened, both Read Only and Hidden are not selectable. Just by chance I tried simplifying the file name. All other excel files in network shares on the same server open in edit mode Hi Iwoods, welcome to the Forum. Something in my computer still recognizes that specific file name as Read Only. 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.
If anything is unclear or if there is anything I can do for you, please feel free to let me know. I have managed to eliminate the problem by switching off the ransomeware shield component of Avast Premier. It means you have disabled read-only in Excel file. It's present under the list of locations that you added. From then on, the copied Excel file would be not read-only and could be used instead of original one.
All my data were on D drive. BitDefender, for example, has content on adding application exclusions here:. They have been working fine for months, this just started yesterday morning. Another User Some Excel spreadsheets, like Word documents, can only be edited by one user at a time. Excel used to prevent using that character in a file name, but my most recent version Mac Office 2011 did not. 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.
When I open the properties of the file before I open it, the check box for read only is unchecked so I believe it should be good to go there. Then took the external and disconnected it. When I removed the slash from the filename using the finder , the Excel file then opened normally. You need to turn off Protected View in Office. Depending on your network setup, the setting might be Enable Protected View for files originating from the Internet. Also I tried disabling the preview pain as JamminJoe suggested didnt work either.
When I first started in this office. When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. Microsoft Office I had some issues with Excel working over a Network share and i would have to wait for like 2 - 3 minutes for the file to become usable. I have also opened a document from local hard drive and that opens and resaves with no problems. For me the problem was bt different and simple. There are actually two security features a. If it can't find the File Location, try re-establishing the shortcut with a new one based on the correct file location.
Click ok when Windows Security Prompt is displayed 10. So here it goes, microsoft needs to improve there coding!! Then you run the script to hide hidden files again. Clear the read-only status of a workbook Note: If your workbook is shared, anyone who has Write privileges can clear the read-only status. There doesn't appear to be any alternative to switching off this component to restore full access to my Excel files. My users access to network share by mapping network drive. I have a Microsoft Excel 2010 file created by User A.