Permission & Access Issues

Fix SharePoint Guest Cannot Use Open in App for Excel Files

Chanuka GeekiyanageChanuka Geekiyanage Nov 3, 2026 869 views

Question details

A guest user needs to open and edit SharePoint Excel files using the desktop application via the Open in app feature, but the action fails.

Fix SharePoint Guest Cannot Use Open in App for Excel Files
Product
Microsoft SharePoint and Excel
Device & OS
not provided
Scenario
A guest user is trying to transition from Excel for the Web to the desktop application to edit a shared SharePoint file.
Observed behavior
The user can access and edit the SharePoint list online, but clicking Open in app does nothing and fails to launch the local Excel application.
Before you start

Verify that the guest user has a desktop version of Microsoft Office installed on their computer and that they are signed into the application with the correct Microsoft work or school account.

Solution 1Recommended

Verify Microsoft 365 License and Software Version

The Open in app feature requires an active Microsoft 365 subscription and a supported Office desktop client.

One-time-purchase versions like Office Professional Plus 2016 or Office 2019 do not fully support this SharePoint cloud integration. Guests must use the Microsoft 365 version of Office apps to seamlessly open files from SharePoint.

1
Open Excel

Launch the local desktop Excel application on the guest's computer.

2
Access Account Settings

Click on File in the top-left corner, then select Account from the bottom-left menu to view the product information.

3
Check Product Information

Look under Product Information to ensure it says Subscription Product Microsoft 365. If it displays Office 2016 or Office 2019, the version is unsupported for this feature.

4
Upgrade if Necessary

If an unsupported version is installed, the user must uninstall it, then download and install a valid Microsoft 365 version using their active work or school subscription.

Verify Microsoft 365 License and Software Version
License Requirement: The guest user's host organization does not automatically grant a desktop license to guests. The guest must have their own valid Microsoft 365 license.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are struggling with complex Microsoft 365 licensing requirements and one-time purchase limitations, WPS Office provides a free, lightweight, and highly compatible alternative. You can easily download files from SharePoint and edit them locally without worrying about subscription barriers.

  1. 1. Download WPS Office: Visit the official WPS website to download the free WPS Office installer.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
  3. 3. Open Downloaded Files: Download your files directly from SharePoint to your computer, right-click the file, and choose Open with WPS Spreadsheets to edit without licensing issues.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Free and lightweight alternative to heavy subscription-based Office suites.Familiar user interface with zero learning curve for Excel users.Easily edit local files downloaded from SharePoint or other cloud drives.
microsoft office alternative - wps office

Frequently Asked Questions

Can I use Office 2016 or Office 2019 to open SharePoint files via Open in app?

No, one-time-purchase versions like Office 2016 and 2019 typically do not support this specific SharePoint cloud integration. An active Microsoft 365 subscription and corresponding desktop app are required.

Why can a guest edit in Excel for the Web but not in the desktop app?

Excel for the Web only requires a compatible browser and the permissions granted by the SharePoint host. Desktop editing, however, requires a locally authenticated, supported Microsoft 365 desktop application linked to a valid work or school account.

What account should a guest use to sign in to the desktop Excel app?

The guest user must sign in using the Microsoft work or school account that was used to accept the SharePoint guest invitation. Personal Microsoft accounts will not authenticate properly with enterprise SharePoint files.