Fix OneDrive 'Open in App' Missing for Shared Excel Files
Question details
External users are unable to use the 'Open in App' option to open cross-organization shared Excel workbooks in the desktop application.

- 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 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.
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.
Ask the folder owner's IT administrator to log into their Azure Active Directory portal.
Request that the administrator adds your email address as a new guest user under 'External Identities'.
Have the file owner delete the previous sharing link to clear any cached permission conflicts.
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.

Clear Local Office Credentials and Cache
If the 'Open in App' button is visible in the web version but clicking it produces an error, corrupted local Office credentials might be blocking the connection.
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. Download WPS Office: Install WPS Office for free on your Windows, Mac, or mobile device.
- 2. Open Your Spreadsheets: Simply download the shared file and open it locally. WPS Office handles all standard Excel formulas effortlessly.
- 3. Share with Ease: Use the built-in file sharing tools to collaborate via secure links without relying on complex enterprise directory setups.

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.




