Forum Discussion

Jon Preston's avatar
Jon Preston
Copper Contributor
Apr 16, 2018

Links to Sharepoint Document in Excel Opens in Browser

Hi   We have several spreadsheets that have hyperlinks to documents in Sharepoint folders. Until recently, when the hyperlink is selected the document would open in the application. However, recent...
office 365
sharepoint
domemsgroup's avatar
domemsgroup
Copper Contributor
Sep 26, 2019

AthenianRazak Agreed its ridiculous. Its a basic requirement for a user to link files wherever they maybe.  

 

This was a fix for one case I came across after a SharePoint Migration. 

 

 

Jentimus's avatar
Jentimus
Copper Contributor
Jan 22, 2020

Here is what I do to make links to SharePoint documents open in their client apps:

1. To make the link work from SharePoint, the library settings (advanced) must be set to open in Client (but if in classic view this setting is ignored).

2. When you paste the link you copy from SharePoint, remove all text after the document extension beginning with the ? (so it just ends with the document extension) – otherwise when someone clicks the link in any MS app, the document opens in a browser.

 

IMO, it would be simpler for SharePoint to simply provide a choice of two versions of link - one that ends in the document extension (call in 'Client link') and one that has the other stuff at the end (call it 'Browser link') but until then this is a fairly easy fix and it works in my world - hope it works for you too!

Resources