Forum Discussion
Files [READ ONLY] but no indication they are, so cannot save changes
I have seen Patricia Hendricks Balik helping some other people, maybe she can provide some insight
Please note that the new version of OneDrive DOES NOT FIX THIS.
Version 2016 (Build 17.3.6798.0207) on Windows 10.
Just ran into this again today:
- Opened file in Teams telling it to open in Excel
- File opened in Excel.
- Does not say READ ONLY in header, and the yellow "edit" bar did not show up.
- Tried to save changes to file and was told it was read only and to save a copy.
- Closed file without saving and reopened.
- This time the yellow "EDIT" bar showed up.
Come on MS. How much time and/or data is lost due to this?
- Rob FarnellFeb 26, 2017Copper Contributor
The only way I have got round this is to un-sync the site and revert to navigating the SharePoint site and opening into Excel that way. Still breaks my preferred workflow, but it may help you for now.
- Ed HansberryFeb 26, 2017Bronze Contributor
Rob Farnell wrote:The only way I have got round this is to un-sync the site and revert to navigating the SharePoint site and opening into Excel that way. Still breaks my preferred workflow, but it may help you for now.
Well, you've "fixed" the OneDrive bug by not using OneDrive. Not really a fix.
- Luke GatchellFeb 26, 2017Copper Contributor
So I think I have some more info on this. After talking to some other co-workers and hearing that they were NOT experiencing the same issue that I was, I started checking into the version of Office 365 that I was running. Lo and behold, I discovered that my Excel was at version 1609, which I believe means it was last updated in October 2016! No matter what I would try to get it to update, it would always tell me that I had the latest version of Office, but since I was on the Current Channel, it was obvious I did NOT have the latest version. 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.
I also had wondered why my PC had STILL never been offered the Anniversary Edition of Windows 10. When I would run Windows Update, it would also tell me I was up to date, but clearly I was not. I even noticed that it would tell me that it was "last checked" on something like 12/3/2016, even though I had just clicked the Check for Updates button minutes ago. Clearly something was amiss. After trying a number of things I discovered that if I unchecked the "Check for updates for other Microsoft Products" it suddenly discovered the Windows update 1607 and so this weekend I finally updated to the Anniversary Edition. Seemed to go pretty well, although as a developer I was disappointed to see it didn't re-install IIS and I lost all my AppPools and test apps, but that wasn't too bad. It also failed to install any .NET versions (I guess because it was really a full install, with a windows.old folder and everything.
But basically, sometime in early November my PC stopped getting Office 365 updates, and sometime in early December my PC stopped getting Windows updates.
I was hoping the OS update would trigger Office 365 to resume updates as well, but alas, it did not. I tried to uninstall Office and it failed. I tried the magic "fix it" download from Microsoft and it failed, too. So I spent an hour or so manually deleting all folders and registry settings. I then ran the "fix it" a few times again and it seemed clean, and I was able to re-install Office 365 with the latest version. (It appeared that I had remnants of Office 2007, Office 2013, and Office 2016 that were confusing things. Just amazing that MS would release such a disaster of a ClickToRun install process that can't clean itself up.) The installer failed at 90%...and I eventually rebooted anyway after waiting for hours and hours. I'm sure there is something messed up with my install now, although i was able to do at least a Quick Repair afterwards (just to see) and it appeared to pass.
All that to say, now I have the latest version of Excel. And guess what? Every time I open an Excel document on my synced sharepoint folder, it prompts me to Edit Workbook...and when I click on the button, it actually works! I can't say that I've done much more than test a few folders and docs, but so far it appears to work as expected (which is what my co-workers said they were experiencing). Incidentally, through all my upgrades and re-installs, I never had to re-install OneDrive or re-sync my folders, which was a nice consolation.
So I'm wondering. What versions of Excel are you guys running, and can you get it to update somehow? I'm now on Excel Version 1611 (Built 7571.2109). And my OneDrive is now at Build 17.3.6743.1212.
Hope this helps someone?