Forum Discussion

Iron Contributor

Feb 14, 2017

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

excel

office 365

SergeiBaklan
Feb 14, 2017
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.

SergeiBaklan

Diamond Contributor

Feb 14, 2017

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 Chapman
Iron Contributor
Feb 14, 2017
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
- bart_vermeersch
  Iron Contributor
  Mar 28, 2017
  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).