A few months ago, we were presented with an issue in MS Excel. However, this issue only occurs when the end user opens an Excel document that is hosted in SharePoint.
If you are using SharePoint and synchronizing files locally with OneDrive for Business, all Excel spreadsheets in you SharePoint folders will open as read-only and display the message:
READ-ONLY We opened this workbook read-only from the server.
Unfortunately, the message might take a few seconds before appearing or the user simply ignores the message and gets to work. If this happens, the user will be forced to save the file with a different name, causing duplicates and issues with data entry.
Yes, Microsoft listened to the end users and is proving an update to put things back to normal. Meaning, update your MS Office to Version 1707 (Build 8326.2096) or higher and the issue will go away.
Important: You will receive MS Office updates based on your subscription and release channel. To learn how to switch between channels, visit this Microsoft article.
Yes! While we were researching this issue, we found 2 main reports:
We believe is related to votes. Meaning, if the suggestion has a low quantity of votes, Microsoft does not consider it an important matter. This behavior is understandable, simply visit the Excel suggestion box and see how many requests they have…
In June 2017, we started experiencing the issue and noticed that the 2 main posts talking about this matter, were not connected. Meaning, people talking about it in TechNet were not voting in Excel.UserVoice.com. Therefore, we started posting comments between multiple communities to make people aware about the suggestion and increase the total votes.
Well, we have succeeded! Back in June 15, 2017, the main request only had 71 votes in a 2-year spam. Now, as of Sep 17, 2017, it has 127 votes and a lot of comments!
All or most products from Microsoft have similar “suggestion box” websites. Use a search engine, such as, Google or Bing, and search for “MS Word Suggestion Box”. Here are a few sites: