Permission & Access Issues

Fix OneDrive 'Open in App' Missing for Shared Excel Files

Steve KSteve K Oct 28, 2026 869 views

Question details

External users are unable to use the 'Open in App' option to open cross-organization shared Excel workbooks in the desktop application.

How to Fix OneDrive Not Showing 'Open in App' for Shared Files
Product
OneDrive / Microsoft Excel
Device & OS
not provided
Scenario
An external user tries to open a shared Excel file via OneDrive in their local desktop application but the option is missing or results in a permission error.
Observed behavior
The file can be edited normally in the web browser, but the 'Open in Desktop App' button is either missing or refuses to load the file locally due to guest access limitations.
Before you start

Before proceeding, verify that you have a compatible version of Microsoft Office installed on your computer and that you are signed in with the same email address that received the shared file.

Solution 1Recommended

Add the External User as a Guest in Azure AD

The most reliable fix for cross-organization sharing issues is to have the file owner's IT department add you as a registered guest in their Azure Active Directory.

When dealing with strict organizational security policies, web-based editing is often allowed for external links, but opening items via the desktop app requires formal authentication. Adding the user as an Azure AD guest bridges this gap.

1
Contact the Host Administrator

Ask the folder owner's IT administrator to log into their Azure Active Directory portal.

2
Add New Guest Account

Request that the administrator adds your email address as a new guest user under 'External Identities'.

3
Revoke Old Link

Have the file owner delete the previous sharing link to clear any cached permission conflicts.

4
Reshare with Guest Account

Ask the owner to generate a new sharing invitation specifically selecting your newly added guest account, then accept the invitation and look for the 'Open in App' button.

Add the External User as a Guest in Azure AD
Administrator Privileges Required: You cannot perform these steps yourself. Only the IT administrator of the organization that owns the file has the necessary clearance to add external guest users.
Free Microsoft Office alternative

Bypass Cross-Organization Headaches with WPS Office

Tired of dealing with complex Azure AD permissions and missing features just to collaborate on a spreadsheet? WPS Office provides a free, highly compatible, and easy-to-manage alternative to complicated enterprise sharing setups.

  1. 1. Download WPS Office: Install WPS Office for free on your Windows, Mac, or mobile device.
  2. 2. Open Your Spreadsheets: Simply download the shared file and open it locally. WPS Office handles all standard Excel formulas effortlessly.
  3. 3. Share with Ease: Use the built-in file sharing tools to collaborate via secure links without relying on complex enterprise directory setups.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) right out of the box.Free, lightweight, and fast alternative to heavy productivity suites.Simple, link-based collaboration without requiring strict Active Directory guest accounts.Familiar user interface ensures zero learning curve when switching.
microsoft office alternative - wps office

Frequently Asked Questions

Why can I edit the Excel file in my browser but not in the desktop app?

Browser-based editing has lower authentication thresholds, making it easier for external users to access. Opening a file directly in the desktop app requires tighter Active Directory authentication, meaning you must be officially added to the host organization's directory as a guest.

Does the 'Open in App' feature require an active Microsoft 365 license?

Yes, to use the 'Open in App' option from a web browser, the device must have a licensed or activated version of Microsoft 365 or a standalone Office suite installed. If your license is inactive, the option may fail to launch.

How can I edit the file with desktop features if I can't get guest permission?

If you are unable to obtain guest permissions from the file owner's IT department, you can download a copy of the Excel file to your local computer. You can edit this offline file using WPS Office or Microsoft Excel, though your changes won't sync live to the owner's OneDrive.

Can I use WPS Office to edit files downloaded from OneDrive?

Absolutely. WPS Office boasts robust compatibility with Microsoft formats, including .xlsx files. You can safely download files from OneDrive, edit them in WPS Spreadsheet, and share the updated version without breaking formatting.