OneDrive Link Opens the Web App Instead of Desktop Office: OneDrive for Business Fix

When you click a shared OneDrive link for a Word, Excel, or PowerPoint file, the file opens in the browser-based Office Web App instead of the installed desktop version of Office. This happens because Microsoft 365 defaults to opening Office files from the web in the browser for speed and security. The behavior is controlled by a tenant-level setting in the Microsoft 365 admin center that administrators can adjust. This article explains why the web app opens by default and provides the exact steps to change the setting so desktop Office launches instead.

Why OneDrive Links Open in the Web App Instead of Desktop Office

Microsoft 365 includes a tenant-level setting called “Office on the web” that controls how Office files behave when users open them from SharePoint or OneDrive links. By default, this setting is configured to open files in the browser for all users. The web app loads faster, requires no local installation, and works on devices that do not have desktop Office installed. However, for users who have a full desktop version of Office, the web app lacks advanced features such as macros, pivot tables in Excel, or full formatting controls in Word.

The setting applies to the entire tenant and overrides any local file association on the user’s Windows machine. Even if the user has .docx files set to open with desktop Word, a OneDrive link will still open in the browser because the URL includes a query parameter that tells the browser to use the web app. The administrator must change the tenant setting to allow desktop Office to handle these links.

A second factor is the Office Cloud Policy service, which can enforce browser-only opening for security reasons. Some organizations deliberately block desktop Office from opening web links to prevent macros or external content from running. In that case, only an administrator can change the policy.

For users who are not subject to a restrictive cloud policy, the fix involves either an admin toggle or a local registry change. The following sections cover both approaches.

Steps to Make OneDrive Links Open in Desktop Office

Use the method that matches your role. Administrators can change the tenant-wide setting. End users can apply a local workaround if the tenant setting allows desktop opening.

Method 1: Change the Tenant Setting in the Microsoft 365 Admin Center

This method requires global admin or SharePoint admin privileges. The change affects all users in the organization.

1. Sign in to the Microsoft 365 admin center
   Go to https://admin.microsoft.com and sign in with an account that has Global Administrator or SharePoint Administrator role.
2. Navigate to Org settings
   In the left navigation pane, select Show all then Settings then Org settings.
3. Open the SharePoint tab
   On the Org settings page, scroll down and select SharePoint. This opens the SharePoint settings pane.
4. Locate the Office on the web setting
   In the SharePoint settings pane, find the section labeled Office on the web. It may be collapsed; click the arrow to expand it.
5. Enable desktop app opening
   Check the box labeled Let people open files in the desktop app instead of the browser when they sign in with their Microsoft 365 credentials. Leave the other settings unchanged.
6. Save the change
   Click Save at the bottom of the pane. The setting takes effect immediately for new links. Existing browser sessions may need to be refreshed or closed and reopened.

Method 2: Use SharePoint Online PowerShell to Force Desktop Opening

If the admin center toggle is missing or does not work, use the SharePoint Online Management Shell to set the tenant property directly.

1. Install the SharePoint Online Management Shell
   Open Windows PowerShell as Administrator and run Install-Module -Name Microsoft.Online.SharePoint.PowerShell. If the module is already installed, skip this step.
2. Connect to SharePoint Online
   Run Connect-SPOService -Url https://yourtenant-admin.sharepoint.com. Replace yourtenant with your actual tenant name. Sign in with a SharePoint admin account.
3. Set the tenant property
   Run Set-SPOTenant -OfficeClientADALDisabled $false. This command enables the desktop client to handle authentication and file opening requests. Wait for the command to complete without errors.
4. Verify the setting
   Run Get-SPOTenant | Select-Object OfficeClientADALDisabled. The output should show False.
5. Test the change
   Open a new browser tab, sign out of Microsoft 365, sign back in, and click a OneDrive shared link. The file should open in the desktop Office application.

Method 3: Local Windows Registry Change for Individual Users

This method works only if the tenant setting does not block desktop opening. It forces the browser to hand off the file to the desktop application.

1. Close all Office applications
   Close Word, Excel, PowerPoint, and Outlook to avoid registry conflicts.
2. Open Registry Editor
   Press Windows + R, type regedit, and press Enter. Click Yes if prompted by User Account Control.
3. Navigate to the Office key
   Go to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Internet. If the Internet key does not exist, right-click Common, select New then Key, and name it Internet.
4. Create the DWORD value
   Right-click in the right pane, select New then DWORD (32-bit) Value. Name it OpenDocumentsReadWriteWhileBrowsing.
5. Set the value to 1
   Double-click the new DWORD, set Value data to 1, and click OK. Close Registry Editor.
6. Restart the browser
   Close and reopen your browser. Click a OneDrive link to verify that the file opens in desktop Office.

If OneDrive Links Still Open in the Web App After the Fix

The admin center toggle is grayed out or missing

This happens when your organization uses Office Cloud Policy to enforce browser-only opening. Only a global admin can change the policy. Go to the Microsoft 365 admin center > Settings > Org settings > Office Cloud Policy. Look for a policy named Use the Office web apps for viewing Office files in the browser. Set it to Disabled or Not configured. Save the policy and wait up to 90 minutes for propagation.

The registry change does not work

The registry value only affects Internet Explorer and Edge Legacy. For Microsoft Edge (Chromium) or Google Chrome, the browser handles the URL protocol directly. In Edge, go to edge://settings/content/pdfDocuments and turn off Always open PDF files externally. For Office files, ensure the tenant setting in Method 1 or Method 2 is applied. Chrome does not support a registry override for Office file protocols.

Desktop Office is not installed

If the user does not have Microsoft 365 Apps for enterprise or a volume-licensed Office version installed, the web app is the only option. Install Office from https://portal.office.com/account under Install and more. After installation, repeat the tenant setting change or registry change.

Web App vs Desktop App: Key Differences for OneDrive Links

Item	Web App (Browser)	Desktop App (Local Office)
File access method	Opens in browser tab via Office Online server	Opens in installed Word, Excel, or PowerPoint
Feature support	Basic editing, comments, co-authoring	Full feature set: macros, pivot tables, advanced formatting
Offline access	Requires internet connection	Works offline if file is synced locally
File size limit	Up to 2 GB for viewing, 100 MB for editing	Limited by system memory and Office version
Third-party add-ins	Limited to Office Store web add-ins	Supports COM add-ins, VBA macros, and third-party plugins
Security restrictions	Macros and ActiveX blocked by default	Macros can run if enabled by user

The table shows that the desktop app offers significantly more functionality. Choose the web app for quick viewing on shared or mobile devices. Choose the desktop app for full editing and automation.

You can now control whether OneDrive links open in the desktop Office app or the web browser. Start by checking the tenant setting in the Microsoft 365 admin center. If you are an end user without admin access, apply the registry change under HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Internet. For organizations using Office Cloud Policy, ask your admin to disable the browser-only policy. After applying the change, test with a shared Word document link to confirm the desktop app launches.