SOLVED

Set preference of opening in Office Online or Office App

%3CLINGO-SUB%20id%3D%22lingo-sub-8241%22%20slang%3D%22en-US%22%3ESet%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8241%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20would%20like%20to%20see%20some%20kind%20of%20preference%20that%20a%20user%20can%20set%20to%20open%20files%20from%20SharePoint%20directely%20in%20the%20Office%20Apps%20instead%20of%20Office%20Online%20when%20clicking%20on%20them.%20This%20saves%20an%20extra%20click%2C%20and%20makes%20that%20SharePoint%20isn't%20showing%20many%20tabs%20for%20all%20opened%20documents%20(and%20next%20to%20that%20our%20users%20prefer%20to%20working%20in%20the%20Office%20Apps).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-8241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112876%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112876%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20I%20experience%20the%20same%20at%20one%20of%20my%20customers%20tenants.%3C%2FP%3E%3CP%3EChrome%20open%20new%20documents%20in%20Office%20Online.%3C%2FP%3E%3CP%3EIt%20also%20opens%20existing%20documents%20in%20Office%20Online.%3C%2FP%3E%3CP%3EAfter%20I%20click%20the%20%22...%22%20and%20Open%20from%20the%20popup%2C%20then%20it%20opens%20in%20the%20Office%20Clients%20instead.%3C%2FP%3E%3CP%3EWeird!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-9212%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9212%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20that%20that%20setting%20only%20works%20in%20IE%20and%20Firefox%20but%20not%20for%20Chrome%20or%20Edge.%3C%2FP%3E%3CP%3EIn%20Chrome%20or%20Edge%2C%20the%20document%20is%20opened%2Fcreated%20using%20Office%20Web%20app%20irrespective%20of%20the%20setting.%3C%2FP%3E%3CP%3EHas%20anyone%20experienced%20the%20same%3F%3C%2FP%3E%3CP%3EI%20am%20using%20Windows%2010.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8320%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8320%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20also%26nbsp%3B...%20Right%20click%20on%20the%20file%2C%20and%20select%20whether%20to%20...%3C%2FP%3E%3CP%3E1)%20open%20in%20Excel%2FWord%2Fetc%20OR%3C%2FP%3E%3CP%3E2)%20open%20in%20Excel%2FWord%2Fetc%20Online.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnless%20that%20is%20the%20extra%20click%20you%20were%20trying%20to%20avoid.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8269%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8269%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20also%20found%20the%20option%20'Open%20Documents%20in%20Client%20Applications%20by%20Default'%20on%20the%20Site%20Collection%20Features%20page%2C%20which%20does%20the%20same%20for%20the%20entire%20Site%20Collection%20(which%20is%20what%20we%20wanted).%20Thanks%20for%20you%20reply%2C%20you%20pointed%20me%20in%20the%20right%20direction%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8252%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8252%22%20slang%3D%22en-US%22%3EAlternatively%2C%20you%20could%20write%20some%20code%20to%20do%20this%20configuration%20in%20an%20automatic%20fashion%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8248%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8248%22%20slang%3D%22en-US%22%3EOn%20the%20Document%20Library%20Settings%20page%2C%20choose%20Advanced%20settings.%3CBR%20%2F%3EOn%20the%20Advanced%20Settings%20page%2C%20in%20Opening%20Document%20in%20the%20Browser%2C%20select%20one%20of%20the%20following%20options%3A%3CBR%20%2F%3EOpen%20in%20the%20client%20application%26nbsp%3B%26nbsp%3B%26nbsp%3BWhen%20a%20user%20chooses%20a%20document%20in%20this%20library%2C%20the%20document%20will%20open%20in%20the%20corresponding%20client%20application%20if%20it's%20available.%3CBR%20%2F%3EOpen%20in%20the%20browser%26nbsp%3B%26nbsp%3B%26nbsp%3BWhen%20a%20user%20chooses%20a%20document%20in%20this%20library%2C%20the%20document%20will%20open%20in%20the%20web%20browser%20in%20the%20web%20app%20for%20that%20document%20type.%20When%20the%20document%20is%20opened%20in%20the%20web%20app%2C%20the%20user%20can%20then%20decide%20to%20open%20the%20document%20in%20the%20client%20application.%3CBR%20%2F%3EUse%20the%20server%20default%26nbsp%3B%26nbsp%3B%26nbsp%3BWhen%20a%20user%20chooses%20a%20document%20in%20this%20library%2C%20the%20document%20will%20open%20by%20using%20the%20default%20open%20behavior%20specified%20for%20the%20server%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-645888%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-645888%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8296%22%20target%3D%22_blank%22%3E%40Sonny%20Gillissen%3C%2FA%3E%26nbsp%3Bcould%20you%20please%20tell%20me%20where%20I%20can%20find%20that%20setting%3F%20There%20seems%20to%20be%20plenty%20of%20coverage%20of%20this%20issue%20in%20relation%20to%20Sharepoint%20but%20not%20the%20Office%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690246%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690246%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20thing%20occurs%20in%20SharePoint%202016%20on-premise.%20We%20cannot%20force%20users%20to%20use%20Internet%20Explorer%2C%20especially%20as%20Edge%20is%20Microsoft's%20recommended%20browser.%20Is%20there%20another%20option%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792251%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792251%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Can%20you%20tell%20where%20is%20that%20menu%20from%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518710%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518710%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1096%22%20target%3D%22_blank%22%3E%40Dean%20Gross%3C%2FA%3E%26nbsp%3B%20where%20do%20you%20access%26nbsp%3B%3CSPAN%3EDocument%20Library%20Settings%20page%3F%20cant%20find%20it%20anywhere%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ETHANKS%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ELouis%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530442%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F726958%22%20target%3D%22_blank%22%3E%40ViGuru%3C%2FA%3E%26nbsp%3B%3CEM%3E%3CSTRONG%3EGreetings!%3C%2FSTRONG%3E%3C%2FEM%3E%3CBR%20%2F%3EYou%20can%20follow%20the%20instructions%20given%20on%3CFONT%20color%3D%22%23FF0000%22%3E%26nbsp%3B%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fwww.syvantis.com%2Fblog%2Fonedrive-opening-online%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.syvantis.com%2Fblog%2Fonedrive-opening-online%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FFONT%3E%26nbsp%3B.%26nbsp%3B%3CBR%20%2F%3EThe%20usual%20warning%3A%20%3CFONT%20color%3D%22%23FF0000%22%3E%3CEM%3EThe%20given%20link%20redirects%20to%20a%20non-Microsoft%20website.%20Proceed%20at%20your%20own%20risk.%3C%2FEM%3E%20%3C%2FFONT%3E%3C%2FP%3E%3CP%3EBTW%20the%20website%20is%20pretty%20safe%2C%20nothing%20to%20worry%20about%20%3B)%3C%2Fimg%3E%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539158%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732421%22%20target%3D%22_blank%22%3E%40DarkPsycho302%3C%2FA%3E%26nbsp%3BChanging%20the%20library%20setting%20to%20open%20in%20desktop%20client%20does%20work%20in%20Chrome%20but%20only%20from%20the%20native%20library%20link.%20If%20you%20add%20a%20link%20to%20say%20a%20quick%20link%20web%20part%2C%20it%20still%20opens%20in%20the%20browser.%20If%20you%20then%20remove%20the%20%3Fweb%3D1%20parameter%20it%20%3CEM%3Eshould%3C%2FEM%3E%20force%20a%20download.%20But%20there's%20no%20such%20option%20to%20force%20a%20single%20doc%20to%20open%20in%20the%20desktop%20app.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20illustrates%20Msft's%20shortsighted%20misunderstanding%20of%20the%20way%20people%20work%20and%20the%20basic%20options%20customers%20need.%20The%20all%20or%20nothing%20approach%20to%20link%20behavior%20is%20sloppy%20at%20best%20but%20more%20likely%20lazy.%20Instead%20of%20wasting%20their%20time%20on%20things%20no%20one%20has%20asked%20for%20or%20cares%20about%2C%20I%20wish%20Msft%20would%20focus%20on%20fixing%20the%20buggy%20modern%20ui%20and%20adding%20options%20like%20this%20that%20people%20might%20actually%20find%20useful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539189%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20preference%20of%20opening%20in%20Office%20Online%20or%20Office%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539189%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20educated%20my%20users%20to%20right-click%20on%20the%20file%2C%20select%20OPEN%2C%20select%20OPEN%20IN%20APP.%26nbsp%3B%20While%20not%20perfect%2C%20it%20is%20a%20work-around%20that%20I%20am%20OK%20with.%26nbsp%3B%20Or%20I%20have%20users%20navigate%20from%20the%20desktop%20app%20(excel%20etc)%2C%20using%20recent%2C%20or%20drilling%20into%20the%20SP%20site%20to%20retrieve%20and%20save%20their%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

We would like to see some kind of preference that a user can set to open files from SharePoint directely in the Office Apps instead of Office Online when clicking on them. This saves an extra click, and makes that SharePoint isn't showing many tabs for all opened documents (and next to that our users prefer to working in the Office Apps).

16 Replies
best response confirmed by Sonny Gillissen (Occasional Contributor)
Solution
On the Document Library Settings page, choose Advanced settings.
On the Advanced Settings page, in Opening Document in the Browser, select one of the following options:
Open in the client application   When a user chooses a document in this library, the document will open in the corresponding client application if it's available.
Open in the browser   When a user chooses a document in this library, the document will open in the web browser in the web app for that document type. When the document is opened in the web app, the user can then decide to open the document in the client application.
Use the server default   When a user chooses a document in this library, the document will open by using the default open behavior specified for the server
Alternatively, you could write some code to do this configuration in an automatic fashion

I've also found the option 'Open Documents in Client Applications by Default' on the Site Collection Features page, which does the same for the entire Site Collection (which is what we wanted). Thanks for you reply, you pointed me in the right direction :)

You can also ... Right click on the file, and select whether to ...

1) open in Excel/Word/etc OR

2) open in Excel/Word/etc Online. 

 

Unless that is the extra click you were trying to avoid.

I found that that setting only works in IE and Firefox but not for Chrome or Edge.

In Chrome or Edge, the document is opened/created using Office Web app irrespective of the setting.

Has anyone experienced the same?

I am using Windows 10.

Yes, I experience the same at one of my customers tenants.

Chrome open new documents in Office Online.

It also opens existing documents in Office Online.

After I click the "..." and Open from the popup, then it opens in the Office Clients instead.

Weird!

Hi, @Sonny Gillissen could you please tell me where I can find that setting? There seems to be plenty of coverage of this issue in relation to Sharepoint but not the Office app.

 

Thanks!

Same thing occurs in SharePoint 2016 on-premise. We cannot force users to use Internet Explorer, especially as Edge is Microsoft's recommended browser. Is there another option? 

Hi, Can you tell where is that menu from?

@Dean Gross  where do you access Document Library Settings page? cant find it anywhere 

THANKS

 

Louis

@ViGuru Greetings!
You can follow the instructions given on https://www.syvantis.com/blog/onedrive-opening-online . 
The usual warning: The given link redirects to a non-Microsoft website. Proceed at your own risk.

BTW the website is pretty safe, nothing to worry about ;) .

@DarkPsycho302 Changing the library setting to open in desktop client does work in Chrome but only from the native library link. If you add a link to say a quick link web part, it still opens in the browser. If you then remove the ?web=1 parameter it should force a download. But there's no such option to force a single doc to open in the desktop app. 

 

This illustrates Msft's shortsighted misunderstanding of the way people work and the basic options customers need. The all or nothing approach to link behavior is sloppy at best but more likely lazy. Instead of wasting their time on things no one has asked for or cares about, I wish Msft would focus on fixing the buggy modern ui and adding options like this that people might actually find useful.

I have educated my users to right-click on the file, select OPEN, select OPEN IN APP.  While not perfect, it is a work-around that I am OK with.  Or I have users navigate from the desktop app (excel etc), using recent, or drilling into the SP site to retrieve and save their file.

that's the extra click they're asking about O:-)
I am having the same issue with some users. Is there a fix for this?

@edwood92 

The feature "open document with client application" work only on the website. If you have outlook, you can activate this option to open link received from SharePoint/onedrive by mail with the app

 

Vertebre85_0-1626295581153.png