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
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 20, 2020

gloriousglenn 

It seems you are confusing a few things.

For co-authoring your file must be saved either to OneDrive or SharePoint.

A file on OneDrive or SharePoint can be opened either with the browser or with the desktop app.

 

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

    Detlef_Lewin 

    OK, so Q1 is answered in the fact that you have said that I need to save the file to OneDrive or SharePoint.  No problem there.

    When I save that file to OneDrive and then share it all I can do is send a link to an email address or copy the link to put it into an email to people.  Having an email with the link is not very convenient for what we need.  Is there not a way of creating a shortcut, similar to how you would create a shortcut on your desktop for a frequently used file on your server?

    I tried to create a shortcut by browsing to the location of that file in the OneDrive folder, but of course if somebody else tries to open that link it is trying to access 'my' OneDrive and they get an error as below:

     

    The only other way is copying the linked provided when I click the 'share' button, but then I can only create an 'internet shortcut' and that will only open the file in a web browser, and I need this to open in the Excel software.

    Any ideas with this?! 

Resources