Fix SharePoint Guest Cannot Use Open in App for Excel Files
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.

- 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.
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.
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.
Launch the local desktop Excel application on the guest's computer.
Click on File in the top-left corner, then select Account from the bottom-left menu to view the 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.
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.

Sign in with a Valid Work or School Account
Guest users must be authenticated with the correct organizational account for SharePoint integration to work.
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. Download WPS Office: Visit the official WPS website to download the free WPS Office installer.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 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.

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.




