Forum Discussion
Links to Sharepoint Document in Excel Opens in Browser
I’ve come across this thread whilst trying to solve a similar problem and wondered if you can help.
I have an excel file that I want multiple users to edit at once so it needs to open in a browser by default. Some of the users are not necessarily that tech savvy so I don’t really want to accompany it with instructions of how to change their settings to make this happen.
From what I can gather, in the url, I need “action=default”. Will this do what I want or if they are currently set up with the default being to open in the desktop app, will it do that instead? If so, do you know how I can get it to do what I want?
To complicate matters a little further, it has a macro that only a small number of users will very occasionally use - I can tell them to then open it in the desktop app after it has opened in a browser but really I then want it opening in their browser next time they use it.
Thanks for any thoughts you have!
job1986 I think that if there is a macro involved that using Excel in a browser is a not a good long term solution. If you are using Office 365, it is possible to have multiple people editing the file at once, what Microsoft calls https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104 and https://support.microsoft.com/en-us/office/document-collaboration-and-co-authoring-ee1509b4-1f6e-401e-b04a-782d26f564a4, using OneDrive. I've trained users to select "Open in the Desktop App" from the menu, sometimes available in SharePoint or to open the desktop app from the browser, but I've had more luck recently having users sync the folder that the Excel file is in with OneDrive. Then from Windows file explorer the user opens the file.
I haven't tried co-authoring this way, but I think that it should work if the User's OneDrive's settings for Office file collaboration has the "Use Office applications to sync Office files that I open" checked (https://support.microsoft.com/en-us/office/use-office-applications-to-sync-office-files-that-i-open-8a409b0c-ebe1-4bfa-a08e-998389a9d823?ui=en-us&rs=en-us&ad=us). It may also require auto-save to the cloud to be enabled.
- Thank you for this. I’ll give it a go!
- hate to open such an old thread, but, did it work?
