Forum Discussion
Force Office Files to Open in Desktop App (via link, from web parts.. in all cases)
This is what I do, hope it helps others.
If you want to take the link and put it in an email, and have that email open directly in the the desktop application, you have to edit two parts of the URL.
Using this as an example:
https://ustsa.sharepoint.com/:x:/r/teams/TestingEnvironment/Test1/Monday%20Meeting%20Notes/2023/MyExample.xlsx?d=wbaa8a4026e3e4a5f8128b28d39e982eb&csf=1&web=1&e=i65YyG
Remove the RED areas:
https://ustsa.sharepoint.com/:x:/r/teams/TestingEnvironment/Test1/Monday%20Meeting%20Notes/2023/MyExample.xlsx?d=wbaa8a4026e3e4a5f8128b28d39e982eb&csf=1&web=1&e=i65YyG
This becomes your new URL that you paste in your email(or whatever):
https://ustsa.sharepoint.com/teams/TestingEnvironment/Test1/Monday%20Meeting%20Notes/2023/MyExample.xlsx
https://tenancy.sharepoint.com/:w:/s/FC_ICT/EWPW2D3KlLJPnQLS-RFATRsBOo3flwaa9raP2pfKUH7cKQ?e=MCA1mq
The site, library and folder path as well as the file name are missing completely. Nothing like what you've shown.
Anyone have any method to force these links to open in the client app. Ideally a method that does not require end users to mess with the URL.
After a lot of poking around , faffing and reading on forums etc I think I've found such a simple way to do it
Open file in app - file > Info> Copy path
Paste this link in to notepad or something similar and just remove ?web=1 from the end of the the link.
Now when you open the link (excluding ?web=1 at the end) it opens in the app and not the browser
Hope this helps others
Just tried the "Copy path" option and removing the "?web=1" in a word document that points to an Excel spreadsheet saved on our Sharepoint site and it still open it in a web page.have you tried change 1 to 0 like "web=0"?
also adding ms-word:ofe|u| in front of your URI also works.
