How to change default document behavior

%3CLINGO-SUB%20id%3D%22lingo-sub-234683%22%20slang%3D%22en-US%22%3EHow%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-234683%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20how%20to%20change%20the%20settings%20for%20how%20documents%20open%20from%20SharePoint%20(and%20Teams).%20Most%20of%20the%20time%20our%20users%20need%20to%20open%20Excel%20in%20desktop%20version%20and%20not%20online.%20But%20they%20have%20to%20click%20and%20select%20Excel%20everytime%20they%20open%20a%20file.%20What%20is%20the%20best%20way%20for%20changing%20default%20settings%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-234683%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276186%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276186%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20changed%20the%20default%20behaviour%20for%20the%20sharepoint%20site%20to%20open%20the%20desktop%20application%2C%20and%20then%20I%20added%20a%20new%20website%20tab%20to%20my%20team%20site%20that%20pointed%20to%20the%20sharepoint%20library%2C%20by%20opening%20the%20files%20in%20that%20tab%20it%20used%20the%20behaviour%20i%20set%20for%20the%20library.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-234702%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-234702%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Anne!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20agree%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F122563%22%20target%3D%22_blank%22%3E%40Stefaan%20De%20Vreese%3C%2FA%3E.%20That%20will%20make%20it%20work%20when%20you%20open%20from%20SharePoint.%20However%20i%20am%20not%20so%20sure%20that%20it%20will%20affect%20the%20behavior%20when%20You%20open%20the%20file%20from%20Teams.%20I%20think%20the%20only%20way%20to%20open%20in%20Office%20Client%20from%20Teams%20is%20to%20press%20the%203%20dots%20and%20select%20%22Open%20in%20Excel%22%20instead%20of%20just%20clicking%20the%20link.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-234687%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-234687%22%20slang%3D%22en-US%22%3EHi%20Anne%2C%3CBR%20%2F%3Eyou%20can%20change%20this%20by%20going%20to%20the%20Document%20Library%20Settings%20%3D%26gt%3B%20Advanced%20Settings%20%3D%26gt%3B%20Opening%20Documents%20in%20the%20Browser%3CBR%20%2F%3EHere%20you%20have%20the%20option%20to%20set%20the%20default%20behavior%20to%20%22Open%20in%20the%20client%20application%22%2C%20which%20will%20open%20every%20Office%20document%20in%20the%20desktop%20app%20and%20not%20online.%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20you%20could%20choose%20to%20activate%20the%20Site%20Collection%20feature%20%22Open%20Documents%20in%20Client%20Applications%20by%20Default%22.%20This%20will%20set%20the%20above%20setting%20for%20every%20Doc%20Library%20in%20your%20site%20collection.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879878%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879878%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20a%20workaround%20for%20this.%26nbsp%3B%20When%20you%20are%20in%20teams%20right%20click%20the%203%20dots%20next%20to%20General%20and%20click%20%22open%20in%20sharepoint%22%3C%2FP%3E%3CP%3EWhen%20in%20Sharepoint%20online%20click%20on%20the%20gear%20next%20to%20your%20picture%20or%20initials%20(in%20the%20top%20right%20of%20the%20screen)%3C%2FP%3E%3CP%3EClick%20on%20Library%20settings%3C%2FP%3E%3CP%3ESelect%20Advanced%20Settings%20in%20General%20Settings%3C%2FP%3E%3CP%3EIn%20%22Opening%20Documents%20in%20the%20Browser%22%20Change%20to%20Open%20in%20the%20client%20application%3C%2FP%3E%3CP%3EGo%20back%20to%20the%20documents%20in%20Sharepoint%20online%20and%20copy%20and%20paste%20the%20entire%20web%20address%3C%2FP%3E%3CP%3EGo%20Back%20to%20Teams%3C%2FP%3E%3CP%3ERight%20Click%20Documents%20Library%20and%20select%20Remove%3C%2FP%3E%3CP%3ESelect%20the%20plus%20and%20select%20website%3C%2FP%3E%3CP%3EName%20it%20whatever%20you%20like%3C%2FP%3E%3CP%3EPaste%20the%20document%20library%20web%20address%20you%20just%20copied%3C%2FP%3E%3CP%3ESelect%20Save%3C%2FP%3E%3CP%3EIt%20will%20now%20open%20the%20desktop%20app%20as%20default%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289134%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20understand%20the%20procedure.%3C%2FP%3E%3CP%3ECould%20you%20help%20me%20with%20some%20screenshot%20%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1307532%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1307532%22%20slang%3D%22en-US%22%3E%3CP%3EBrilliant!%20Thanks!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386728%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3B%20You%20are%20a%20genius!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393184%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393184%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20it%20through%20most%20of%20the%20steps%20but%20can't%20find%20%22%3CSPAN%3ERight%20Click%20Documents%20Library%20and%20select%20Remove%22%20in%20Teams.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399817%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669309%22%20target%3D%22_blank%22%3E%40Tammy44%3C%2FA%3E%26nbsp%3B%26nbsp%3BSame%20here.%20Anyone%20find%20where%20this%20is%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1432539%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432539%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669309%22%20target%3D%22_blank%22%3E%40Tammy44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20this%20is%20done%20by%20right%20clicking%20on%20the%20tabs%20up%20the%20top.%20You%20can%20not%20remove%20the%20default%20'Files'%20tab.%3C%2FP%3E%3CP%3EI%20can%20remove%20a%20manually%20created%20Document%20library.%26nbsp%3B%20Additionally%20If%20I%20add%20a%20manual%20Documents%20library%20(by%20adding%20a%20new%20tab%20%2B)%26nbsp%3B%20following%20the%20steps%20it%20still%20opens%20in%20the%20teams%20and%20not%20the%20app.%26nbsp%3B%20Do%20I%20need%20to%20remove%20the%20default%20%22files%22%20tab%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1432583%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686135%22%20target%3D%22_blank%22%3E%40GrahameB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20take%20that%20back%2C%20it%20did%20work.%20I%20created%20a%20new%20document%20library%20when%20I%20should%20of%20just%20created%20a%20web%20link%20to%20the%20SharePoint%20site.%26nbsp%3B%20this%20opens%20up%20SharePoint%20within%20a%20teams%20window.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467548%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467548%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3Bi%20dont%20see%20library%20settings%20when%20i%20click%20on%20the%20gear%20next%20to%20my%20initials%20in%20sharepoint%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498679%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20document%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416536%22%20target%3D%22_blank%22%3E%40ahilburn2019%3C%2FA%3E%26nbsp%3B%20This%20is%20awesome.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

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?

13 Replies
Highlighted
Hi Anne,
you can change this by going to the Document Library Settings => Advanced Settings => Opening Documents in the Browser
Here you have the option to set the default behavior to "Open in the client application", which will open every Office document in the desktop app and not online.

Or you could choose to activate the Site Collection feature "Open Documents in Client Applications by Default". This will set the above setting for every Doc Library in your site collection.
Highlighted

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.

Highlighted

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. 

Highlighted

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

 

Highlighted

@ahilburn2019 

I don't understand the procedure.

Could you help me with some screenshot ?

Thank you

Highlighted

Brilliant! Thanks!@ahilburn2019 

@ahilburn2019  You are a genius!

Highlighted

@ahilburn2019 

I made it through most of the steps but can't find "Right Click Documents Library and select Remove" in Teams. 

 

Highlighted

@Tammy44  Same here. Anyone find where this is? @ahilburn2019 

Highlighted

@Tammy44 

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?

Highlighted

@GrahameB 

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.  

Highlighted

@ahilburn2019 i dont see library settings when i click on the gear next to my initials in sharepoint?

Highlighted

@ahilburn2019  This is awesome. Thanks!