Forum Discussion

FBorges's avatar
FBorges
Copper Contributor
Nov 23, 2018
Solved

Excel book located in Sharepoint open as "read only" by default

Hi, Is it possible to desactivate the default "read only" protection when we open an Excel book located in Sharepoint? The users have to click "Edit Workbook" to save the document with the same nam...
excel
Excel Online
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 24, 2018

Hi,

 

With the introduction of co-authoring mode that disappeared, please check https://blogs.technet.microsoft.com/office_integration__sharepoint/2015/11/12/excel-2016-opens-sharepoint-workbooks-as-read-only/, thus for today that's version issue.

Also

https://tcsp360.com/blog/issues-and-solutions/ms-excel-2016-opens-workbooks-read/

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10205019-read-only-mode

  • FBorges's avatar
    FBorges
    Copper Contributor
    Nov 26, 2018

    Hi Sergei,

    Thanks for your reply.

    I've realised that we are still working with version 16.0.9

    Thank you for your help.

    Regards

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 26, 2018

      You are welcome. Hope you'll update soon.

      • FBorges's avatar
        FBorges
        Copper Contributor
        Nov 26, 2018

        Hi again Sergei,

        I was wrong about the version... We have already 1803.

        Is it possible that have been changes after version 1707?