02-25-2020 10:12 AM
02-25-2020 10:12 AM
I currently have a lot of users sharing a small excel file which is currently over OneDrive but im seeing a few minor teething issues with so many people connected (<15 people).
The file itself is stored on sharepoint.com site and so I wondered if its possible to directly open this file with the desktop app?
The problem im experiencing is, I can browse the folder structure and open this in Windows explorer, however if I close the webpage down it appears to drop the credientials and the location is no longer available through windows explorer.
I've tried desktop shortcuts directly to the file, to the parent folder but all drop the access once the webpage is closed.
Is there another way of achieving this? I really wanted to strip out any middle software such as OneDrive or Teams and just go straight to the Sharepoint File.
02-25-2020 10:18 AM - edited 02-25-2020 10:19 AM
Have you tried getting a link to the file from SharePoint and then creating a Shortcut in Windows using the link?
Right click the file in SharePoint and choose 'Copy Link'
In Windows, create a Shortcut and paste the link as the path.
Users can also pin the link in Excel recent files.
02-25-2020 10:36 AM
Yes I've tried this and the link within the shortcut will work however it always opens the web page version of the office file as opposed to the desktop App.
The shortcut is along the lines of;
I've tried cutting it back to;
and it simply downloads a copy of the file.
02-25-2020 10:40 AM
I also came across this: https://www.syvantis.com/blog/open-office-files-in-their-desktop-app-now-by-default and have tried enabling this too without it making any difference.
02-25-2020 11:20 AM
Yes, and that works well when opening the file through Sharepoint, but for the most part all users are used to have a desktop shortcut, so desperately want to try and stick with a desktop app shortcut if possible.
It sounds so easy and should be straight forward but its not :(
02-25-2020 11:25 AM
This Site suggests the Sharepoint site should be added to the Internet Explorer trusted sites, which is something i'll need to try and test when im back in work tomorrow. This could be why the credentials/ is dropping after closing down the webpage.
02-25-2020 01:59 PM
02-25-2020 02:00 PM
02-26-2020 12:46 AM
I haven't done a comparison but with the Auto Save on it shouldn't make much difference. Assuming you are on Win10 and latest version of Office.
What I have seen is that co-authoring with Excel and lots of users, especially if they are large spreadsheets doesn't work very well. We have had to stop co-authoring on some excel workbooks and turn on checkout/in instead.
02-26-2020 04:09 AM
@Adam1V If your users can't learn how to pin a file in modern office so it's always on their list, then create the shortcut and open in browser then select open in desktop app from the browser and select "always do this for this type of file"
02-26-2020 09:51 AM
Just to confirm, adding the mycompany.sharepoint.com to the list of trusted websites has resolved the issue. I can now browse the folder structure anytime without first having to open the browser and connect. This allows me to create a desktop shortcut direct from SharePoint Online.