Clearly the message I'm getting is bizarre because my machine clearly can connect to the server, or none of this would by syncing, etc. In all of these cases, moving or saving the spreadsheet to a folder where you have full permissions will allow you to make changes. A lot of variables in play, but the behavior is consistent regarding the Excel files opening in read-only. At the top under the General tab will be a box checked if the worksheet is locked. For Read-Only problem, this problem may related to the permissions for users. Note that an article on suggests this is due to an update from Microsoft causing the issue.
I'd have to close it, and then open it from file explorer. If I browse to the file on Office 365 within the browser, and click on it, it opens. I get the following dialogue boxes. In order to save my work I have to save with a different name, and after that everything resets and I am free to save over the original file. Doesn't seem to have any link to how long the file has been open, or the size of the file.
I have not tried that yet. Have you guys submitted this through the Report a Problem menu when you right-click on the System Tray menu? I know it is kind of hard without being able to have it in front of you. After nearly a year, I've given up. The reason is you probably don't have permission to read and write. Not saying that it all couldn't break in a moment. On my desktop, I followed procedures required to install Office 2016.
We do not use file redirection, and I made sure the users did not have the file open in the Preview Pane when the problem occurred. It makes no sense to me as I have never ran across an issue like this before. In the same tab you used to unlock the file, check the box to lock it. This does, however, prevent you from being able to change anything else. I'm now on Excel Version 1611 Built 7571.
Whilst this is an obvious work around, I am looping through about 40 files, and have to do this manually in each open instance. How long is the document being kept open? In addition, you can provide us a screenshot of what's exactly showing on your computer when opening the Excel file. What originally caused the problem was this. Either way, I have some settings ideas I'll play around with when I get to work. If you have feedback for TechNet Support, contact. I don't know if I uninstalled Office 2003. Uncheck this to unlock it.
The files were copied both ways in Explorer over a network. So far, I'm not planning to move our team from Groove if this unreliableness continues. Anytime a user would complain about a broken file like this, we'd gently remind of the reboot policy. You would need to ask the original file creator to resend it after updating your permissions. Not an everyday issue, but there are days where it happens several times throughout the day, with no rhyme or reason. The problem still persists though.
Thank you for all the valuable information that has been posted. I'm about to do that. I thought doing a re-sync would work. I have the latest ends in. Using Save As instead of Save is a workaround, and it's what my users are doing on the rare occasions when this problem occurs. The installer failed at 90%. My suspicion was that when you tell OneDrive to let Office 2016 handle the syncing, it does -- but then if you are stuck with an old version of Office 2016, it doesn't do it correctly.
Adding the network folder location to Trusted Locations. So when you disable share feature, users will work fine. The majority of our users did their daily reboots after awhile which cut down on this issue. Not the answer you're looking for? There are several possible reasons for an Excel worksheet to say it is Read Only. . Unlocking Made Simple The key to unlock an Excel 2011 or 2016 worksheet is in the File menu of the Finder feature on your computer. So I wonder if something in the way Excel saves the link is an issue.
Also, try to open the copied Excel using the Open with. First, have her log on with her profile on a different computer. Next have a different user log onto her computer and open the file both locally and from the network. Disabling Auto Recover and Autosave. Browse other questions tagged or.