Microsoft 365 app launcher on office.com showing Outlook, Word, PowerPoint, SharePoint, OneDrive, Excel, OneNote and Teams

Photo by Ed Hardie / Unsplash

How to Automatically open SharePoint File in Desktop App

SharePoint Sep 4, 2025

By default, SharePoint often opens Word, Excel, and PowerPoint files in the browser, which can be limiting if you prefer the full functionality of the desktop apps. Fortunately, there are several ways to change this behavior. It can be set at the library level, applied across an entire site, or on a file-by-file basis. We’ll cover three methods to make sure your SharePoint files open directly in their desktop applications for a smoother editing experience.

1. Set it at the document library level

If you have full control as a Site Owner over a specific document library:

  • Go to your SharePoint site and open the desired document library.
  • Click the gear icon (⚙️) and choose Library settings.
SharePoint Documents library with the Settings gear menu open and Library settings highlighted
  • Select More Library Settings.
SharePoint Library settings panel with the More library settings link highlighted
  • Select Advanced settings.
Document library Settings page with Advanced settings highlighted under General Settings

  • Under Opening Documents in the Browser, choose Open in the client application.
Advanced Settings page with Open in the client application selected under Opening Documents in the Browser
  • Scroll to the bottom and click OK to save.
Bottom of the library Advanced Settings page with the OK button highlighted

Now, anyone opening Word, Excel or PowerPoint files from that library will have them launch in the desktop app by default.


2. Apply it site‑wide to all libraries

As a site‑collection administrator, you can enforce the setting across an entire site:

  • On the top‑level site, click the gear icon and select Site information, then choose View all site settings.
SharePoint site home page with the Settings gear menu open and Site information highlighted
SharePoint Site Information panel with the View all site settings link highlighted
  • Under Site Collection Administration, click Site collection features.
SharePoint Site Settings page with Site collection features highlighted under Site Collection Administration
  • Find Open Documents in Client Applications by Default and click Activate.
Site collection features list with Open Documents in Client Applications by Default and its Activate button highlighted

This turns on the desktop-app default for every document library in the site collection that is set to Use the server default, which is where libraries start out. A library you have already set to Open in the browser keeps its own setting.


3. Manual override (available to all users)

Even without admin permissions, you can still open a file in the desktop app at any time:

  • Navigate to the file in the library or in OneDrive for Business.
  • Click the ••• (More) button next to the file name.
  • Choose Open → Open in app.
File menu in a SharePoint document library showing Open, then Open in app

This opens the file in the desktop app, as long as the Office desktop apps are installed on that computer.


Bonus: Set the Same Preference in Teams

Files opened from Teams follow their own setting, not the SharePoint library setting. In the Teams desktop app, go to Settings and more > Settings > Files and links and look for Always open Word, PowerPoint, and Excel files in. Choose Desktop app. If that option is missing, the Office desktop apps either aren't installed or aren't included in your license.

The library and site settings only apply to files opened from the SharePoint or OneDrive web pages. If you want file links clicked in classic Outlook, Word, Excel, or PowerPoint to open in the desktop apps too, Microsoft has a separate Open in Desktop group policy for Windows. Users can still override it with their own file open preference.

Before You Switch: Users Without Desktop Apps

If some people in your organization only have the web apps, such as users on Microsoft 365 Business Basic, think twice before setting a library to open in the client application. The setting says it falls back to the browser when the desktop app isn't available, but in practice the click can fail silently for those users. In mixed-license organizations, it's usually safer to leave libraries on Open in the browser and let people with desktop apps use Open > Open in app.

For more on how SharePoint handles files, see SharePoint vs OneDrive and Why Does SharePoint Keep Asking for My Credentials?, which covers another common snag when opening files in the desktop apps.


Between the library setting, the site collection feature, and the Open in app option, you can make SharePoint files open in the desktop apps for yourself or for everyone who uses your site. Let me know any questions below and thanks for reading!

Last updated:

Tags

Sean Shares

Microsoft Administrator with 20 years of experience helping users and IT pros get more out of Microsoft 365. Started in SharePoint on-prem and now covers the full M365 stack.