Aug 21 2018 04:35 AM
Aug 21 2018 04:35 AM
I am looking for how to change the settings for how documents open from SharePoint (and Teams). Most of the time our users need to open Excel in desktop version and not online. But they have to click and select Excel everytime they open a file. What is the best way for changing default settings?
Aug 21 2018 04:42 AM
Aug 21 2018 05:20 AM
Hi Anne!
I agree with @Stefaan De Vreese. That will make it work when you open from SharePoint. However i am not so sure that it will affect the behavior when You open the file from Teams. I think the only way to open in Office Client from Teams is to press the 3 dots and select "Open in Excel" instead of just clicking the link.
Oct 21 2018 09:31 PM
Hi
I changed the default behaviour for the sharepoint site to open the desktop application, and then I added a new website tab to my team site that pointed to the sharepoint library, by opening the files in that tab it used the behaviour i set for the library.
Sep 27 2019 01:08 PM
There is a workaround for this. When you are in teams right click the 3 dots next to General and click "open in sharepoint"
When in Sharepoint online click on the gear next to your picture or initials (in the top right of the screen)
Click on Library settings
Select Advanced Settings in General Settings
In "Opening Documents in the Browser" Change to Open in the client application
Go back to the documents in Sharepoint online and copy and paste the entire web address
Go Back to Teams
Right Click Documents Library and select Remove
Select the plus and select website
Name it whatever you like
Paste the document library web address you just copied
Select Save
It will now open the desktop app as default
Apr 07 2020 10:06 AM
Apr 14 2020 04:26 PM - edited Apr 14 2020 04:27 PM
Brilliant! Thanks!@ahilburn2019
May 15 2020 08:19 AM
I made it through most of the steps but can't find "Right Click Documents Library and select Remove" in Teams.
May 18 2020 09:24 AM
@Tammy44 Same here. Anyone find where this is? @ahilburn2019
Jun 01 2020 09:16 PM
I think this is done by right clicking on the tabs up the top. You can not remove the default 'Files' tab.
I can remove a manually created Document library. Additionally If I add a manual Documents library (by adding a new tab +) following the steps it still opens in the teams and not the app. Do I need to remove the default "files" tab?
Jun 01 2020 10:33 PM
I take that back, it did work. I created a new document library when I should of just created a web link to the SharePoint site. this opens up SharePoint within a teams window.
Jun 16 2020 06:05 AM
@ahilburn2019 i dont see library settings when i click on the gear next to my initials in sharepoint?
Jun 30 2020 07:05 AM
@ahilburn2019 This is awesome. Thanks!
Aug 23 2021 06:33 AM
Feb 07 2023 01:22 PM
So, how do you activate the Site Collection feature "Open Documents in Client Applications by Default?"
Feb 07 2023 01:49 PM