Files [READ ONLY] but no indication they are, so cannot save changes

Bronze Contributor

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.

46 Replies

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?


@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.

Interesting. Maybe all the other updates I did, plus all the registry cleaning and uninstalling of other Office versions was what really was causing the problem and ended up fixing it. All I can say is that every file I've interacted with over the last few days has properly shown the Edit Workbook button, and every time I click it, it works (I haven't seen the "can't contact the server" message yet).

Not saying that it all couldn't break in a moment. :) I did, incidentally, update Office this morning and it grabbed the 2/23 release, so it now truly is up to the latest Current Channel (although not ahead on the Fast Ring like you).

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.

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.

Yes, very irritating. I'll definitely be keeping an eye out. I did notice that I had to open all the files in my recent/pinned list before it would show the Edit Workbook button (and then it does everytime after that). So I wonder if something in the way Excel saves the link is an issue.

I've tried numerous old files that I've not opened for years and so far I'm getting prompted by those each time. But we'll see. I know MS says this isn't a "support forum", but I'm not sure where there is such a forum if this isn't it!

Any progress or fixes on this issue? Some customers are getting this problem with the new Onedrive

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.

To fix this:

 

you must go to the onedrive settings > office tab

uncheck the collaboration option. The read only/save problems dissapear.

 

 


@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.

No but atleast the users are not losing a day of progress after pressing save and nothing gets saved!

@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!

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.

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!!

 

so, did Microsoft say something about this, still waiting?

 

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!!

Hi, After deleting the HTTP verbs in IIS request filtering my issue got resolved. Try this once.

 

https://docs.microsoft.com/en-us/iis/configuration/system.webserver/security/requestfiltering/filter...

 

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.

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.

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:

 

https://support.office.com/en-us/article/why-did-my-file-open-read-only-3ab4b792-da50-4b38-8628-14c6...