Jan 11 2017 08:07 AM
I have the latest (ends in .1212) client and am still seeing an issue that has been there since the initial release back in Sept/Oct.
I can open a file in Excel, either from the MRU list in Excel, using the File|Open menu, or double-clicking on a file in Windows Explorer. (Win10).
The file opens and there is no yellow bar that says it is read only with the [EDIT] button to use the file. The title bar in Excel with the file name doesn't say [READ ONLY].
You only find out it is read only when you try to save, and Excel tells you you cannot and then offers to save a copy.
The fix is to close and reopen the file. Then the yellow EDIT bar comes up. But of course you've lost any changes.
This never happened with the old Groove client, so this is something unique to this new much improved client.
I've reported this through official channels via the REPORT A PROBLEM menu in OneDrive but nothing ever substantive comes from it. "Run a /reset command", "reinstall", "resync the library", "oh yeah, we know about that, thanks"
But we are getting close to release and I'd love to see this fixed.
Feb 26 2017 07:57 PM
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?
Feb 27 2017 10:08 AM
@Luke Gatchell wrote: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.
While you should certianly be on the latest version of Excel, this isn't the issue. I am on the Fast Ring build, so way ahead of what is in the current or deferred channel, and we also have people here in the office with the confirmed latest versions in the current channel.
Feb 27 2017 11:17 AM
Feb 27 2017 11:28 AM
I hope you have fixed it for you, but give it time to fail again. I've noticed that it rarely fails on the same file, so if you are working on a bunch of the same files over a few days, it should work ok. I most often get bitten when working on a file I've never worked on before, or not in a long time - like weeks or even a few months. It seems to me that ODB needs to cache some info about the file.
Irritating as heck. Almost as irritating as MS's silence and notable absence in this thread.
Feb 27 2017 12:06 PM
All - please report this to MS and even link to this thread. Right-click on the blue cloud in your system tray and select "Report a problem."
But don't run any /reset commands on your OneDrive. THat will not fix anything and will just erase any preferences you have set in checking/unchecking any folders to sync.
Feb 27 2017 12:07 PM
May 16 2017 03:50 AM
Any progress or fixes on this issue? Some customers are getting this problem with the new Onedrive
May 16 2017 11:14 AM
We constantly get this issue here. SUPER frustrating. The good news is the Fast Ring Excel version largely eliminates this. The bad news is, it is test only and has other bugs, so we don't dare roll it out wide.
May 18 2017 08:10 AM
To fix this:
you must go to the onedrive settings > office tab
uncheck the collaboration option. The read only/save problems dissapear.
May 18 2017 11:47 AM
@IT aanspreekpunt wrote:To fix this:
you must go to the onedrive settings > office tab
uncheck the collaboration option. The read only/save problems dissapear.
Hmmm. thanks. That also disables the ability to share files from inside the Office app. Not ideal in the least.
May 18 2017 10:48 PM
Jun 21 2017 07:54 AM - edited Jun 21 2017 07:55 AM
@Ed Hansberry wrote:
@IT aanspreekpunt wrote:To fix this:
you must go to the onedrive settings > office tab
uncheck the collaboration option. The read only/save problems dissapear.
Hmmm. thanks. That also disables the ability to share files from inside the Office app. Not ideal in the least.
I have also seen this cropping up with my users and had to use this as a "temp" fix. Hopefully MS will fix this soon!
Jul 17 2017 08:40 AM - edited Jul 17 2017 08:42 AM
Experienced this today with Excel files when opening them from Ms Teams. I have the latest updates of OD and Excel. I had wanted to start a new conversation about this, when this thread was shown up. Thank you for all the valuable information that has been posted. I'll untick the collaboration setting in the OD client as a temporary solution.
Thanks and keep us posted if there is any update to the status of this bug.
Aug 02 2017 07:18 AM
I have just started getting this problem with Excel:
(Excel 2016 - Office365 - version 1701 Build 7766.2096)
Windows Insider 16251
Onedrive 2016 Build 17.3.6955.0712
I have spreadsheet that I can open and hit the save button at say midday and then a couple of hours later save and get the unable to save message. So it's not set to read only as I have saved it earlier in the day!!
Aug 30 2017 07:24 AM
so, did Microsoft say something about this, still waiting?
Aug 30 2017 07:39 AM
Since posting this and having loads of problems with that version of office upgraded to Version 1707 (build 8326.2070 Click-to-Run). No longer have the problem!!
Jan 03 2018 03:39 AM
Hi, After deleting the HTTP verbs in IIS request filtering my issue got resolved. Try this once.
Jan 29 2018 11:56 PM
We've seen this issue with multiple customers. It's really disappointing MS has not addressed this with more urgency. We're losing customers left and right to Box and Dropbox due to issues like these.
Jan 30 2018 12:40 PM
Just curious - what version of OneDrive and Office are you running? I've not seen this problem here for at least 6-7 months, so it seems fixed for me.
Feb 01 2018 03:40 PM
Just saw this issue this morning with a customer using:
Win 10 (10.0.16299.192)
OneDrive Client (17.3.7294.0108)
Office 2016 (1708 8431.2153)
This customer is going through a file share migration to SharePoint Online and Win 7 update to Win 10. A lot of variables in play, but the behavior is consistent regarding the Excel files opening in read-only. Opens normally if the “Use Office 2016 to sync…” is unchecked.
I saw this in the following recent post, so I assumed it’s still being looked at: