Skip to main content
< All Articles

How to default Office files to open in the native app from SharePoint and OneDrive

Posted on March 23, 2021
SharePoint

By default, when you click on Word, Excel, or PowerPoint files from SharePoint or OneDrive, they open up in the browser. That is the default experience for these file types. The browser experience opens files quickly, allows you to make the changes “on the fly,” and best of all –the changes are auto-saved back to SharePoint or OneDrive. However, if you are doing serious editing, have fancy formatting, or, say, working with advanced formulas in Excel – you will need to open the Office files in their native (desktop) app. In this article, I would like to explain how to default Office files to open in the native app from SharePoint and OneDrive.

Manual Option

Any user at any time can manually bypass the browser experience. Right-click above the file > Open > Open in app Defaultofficefilesnativeapp1

How to default Office files to open in the native app

If you would like to automatically have the Office files open in the native (desktop) applications, then you would need to change some settings behind the scenes. Instructions are a bit different for SharePoint and OneDrive.

SharePoint Document Library

If you want to default Office files to open in the native app for a specific document library – please follow the instructions below.

  1. Navigate to the document library, click Gear Icon > Library settings Defaultofficefilesnativeapp2
  2. Click on Advanced settings open in the native app from SharePoint and OneDrive
  3. Under Opening Documents in the Browser section, change the radio button to Open in the client application. Click OK at the bottom of a page. open in the native app from SharePoint and OneDrive

Consulting Assistance1

SharePoint Site

If you want to default Office files to open in the native app for the whole SharePoint site (all document libraries located on that site) – please follow the below instructions instead.

  1. Gear Icon > Site Information Defaultofficefilesnativeapp5
  2. Click View all site settings Defaultofficefilesnativeapp6
  3. Click on the Site collection features Defaultofficefilesnativeapp7
  4. Click Activate next to Open Documents in Client Applications by Default open in the native app from SharePoint and OneDrive

OneDrive

If you want to default Office files to open in the native app in your own OneDrive, here are the instructions.

  1. From your OneDrive page, click Gear Icon > OneDrive settings Defaultofficefilesnativeapp9
  2. Click More Settings Defaultofficefilesnativeapp10
  3. Click on Site collection features open in the native app from SharePoint and OneDrive
  4. And just like with the SharePoint example above, click Activate next to Open Documents in Client Applications by Default open in the native app from SharePoint and OneDrive

Notes

  • The above techniques only work for docs open from the library, not sharing links. When you share or copy links to files – they will always open in the browser Shareandcopylinksharepoint1
  • The above techniques only work for Office file types (Word, Excel, PowerPoint, OneNote). Other file types (i.e., PDF) are not supported
  • When you create new documents using the New drop-down buttonthey will still open in the browser despite the changes you make above Defaultofficefilesnativeapp13
  • The same applies to the files created from a Template from the New drop-down. These files will open in the browsers no matter what. 5waystostoredocumenttemplates12
  • Unlike the browser experience, where AutoSave is on by default and can’t be disabled, AutoSave can be controlled from Office settings (File > Options) open in the native app from SharePoint and OneDrive
  • If users open the files in the native (desktop) applications, when you click the Save button from Word/Excel/PowerPoint – the files go back to where they came from (SharePoint document library or OneDrive)
  • Reference this post as well for a full list of limitations of browser vs. desktop experience

About Me

I’m Greg Zelfond, a U.S. based SharePoint consultant, and I provide affordable out-of-the-box SharePoint consulting, training, and configuration assistance to small and medium-sized businesses all over the world.

Need help?