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.
Tried below workaround that I found searching the internet, and it does work. Recommend only doing this on spreadsheets you edit frequently as you end up converting them into Macro-enabled (.xlsm) spreadsheets. Go into the VBA module (press Alt-F11). Double click on ‘ThisWorkbook’ and add the following lines (between the dashes): -------------- Private Sub Workbook_Open() ActiveWorkbook.LockServerFile End Sub ------------- You will need to save as a macro-enabled workbook (.xlsm), and do this for every SharePoint file you want to automatically open as Read-Write with Excel 2016…