Forum Discussion

gloriousglenn's avatar
gloriousglenn
Copper Contributor
Oct 20, 2020

Sharing vs Co-Authoring a Spreadsheet

Prior to migrating to Office 365, as an office, we have been sharing a specific spreadsheet which has been working fine, with its limitations.   Now we have moved across to Office 365 we have looke...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 20, 2020

gloriousglenn 

As far as I could understand the translation, you would like to work on a workbook together.

Here is some information about it:

Collaborate on Excel workbooks at the same time with co-authoring

https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-us&rs=en-us&ad=us


If it is not the case and not what you are looking for, please just ignore the information.
 

Thank you for your understanding and patience

 

I would be happy to know if I could help.

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)

  • gloriousglenn's avatar
    gloriousglenn
    Copper Contributor
    Oct 20, 2020

    NikolinoDE
    Thanks.  I do understand the basic concepts of the co-authoring, but having a specific issue.

    Background:  We have a "Schedule" that is a spreadsheet, located in a particular part of our server (G:\Training Schedule\2020 Schedule.xlsx).  This file is shared in the 'old way' as a "Shared Workbook" and works well apart from the lack of some functionality.
    Problem: Now that we have migrated to Office 365 I want to be able to use co-authoring (giving us the better functionality), but to do so I have to save the file to my work OneDrive account.  I'm fine with that, but I would like a link to that file in the G:\Training Schedule\ folder that will allow all staff members to be able to click on it and open the file in it's native Excel format (not browser format).    

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 20, 2020

      gloriousglenn 

      The easiest way is to use Microsoft Teams if you have it in your subscription. That's the tool designed to share and communicate common resources by teams and group charts. From the Teams interface you may open the file in Teams interface (which is actually embedded browser), in browser and in desktop application. Everything is naturally shared.

       

      Without Teams if you have only OneDrive interface you may find all shared files, shared both by you and with you

      Any file could be opened in browser or in application if it is supported

      Default behavior also could be set, at least for SharePoint libraries, perhaps for OneDrive as well.

Resources