Forum Discussion
Solved
Adding SharePoint Online site(s) to Trusted Locations in Excel 2016
Hello, When users open their files in Excel from SPO they get the yellow 'READ-ONLY' bar and are prompted to Edit Workbook. I can see why it works that way. However, I was looking to see if it wa...
Paul, not sure how to resolve this, but that's not due to unsafe location, that's to avoid unnecessary locking of the file. See here https://blogs.technet.microsoft.com/office_integration__sharepoint/2015/11/12/excel-2016-opens-sharepoint-workbooks-as-read-only/. Not sure if something changes recently, at least i know nothing.
Paul, not sure how to resolve this, but that's not due to unsafe location, that's to avoid unnecessary locking of the file. See here https://blogs.technet.microsoft.com/office_integration__sharepoint/2015/11/12/excel-2016-opens-sharepoint-workbooks-as-read-only/. Not sure if something changes recently, at least i know nothing.
Thanks Sergei, you are right. I was barking up the wrong tree. Looks like there is no option to change the behaviour (yet) but at least I now know lots of other people are also annoyed about it! :)
Paul
Paul
If I'm not mistaken, there is an idea you can support on uservoice for this request.
I hope, with the recent annoucement that co-authoring in Excel became available in Office insider, it is just a matter of a few months before this will be changed (unless it need to stay compatible with older versions and thus locked for another year).
