'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix External User Cannot Open OneDrive or SharePoint Excel File in Desktop App
Question details
An external user with edit permissions is unable to open a shared Excel file hosted on OneDrive or SharePoint using the Excel desktop application, particularly when accessing it via a personal email address.
- Product
- Microsoft Excel, OneDrive, SharePoint
- Device & OS
- not provided
- Scenario
- Collaborating on shared Excel files with external guests who use personal email accounts.
- Observed behavior
- The external user can view or edit the file online but cannot open it in the desktop app despite having the necessary edit permissions.
Ensure the external user is logged into the Excel desktop app with the exact email address that received the sharing invitation, and verify they have an active Microsoft 365 license if required for desktop editing.
Verify Tenant Subscription and Guest Account Configuration
Administrators must ensure the Microsoft 365 tenant allows external desktop app access and that the guest is properly added to the directory.
Personal email addresses (like Gmail or Yahoo) often face limitations when trying to access SharePoint or OneDrive files directly through Microsoft desktop applications. The host organization's tenant must be configured to allow this level of guest access.
Have the tenant administrator log into the Microsoft Entra admin center (formerly Azure AD).
Navigate to Users > All users and confirm that the external user's personal email is properly configured as a Guest user in the directory.
Go to the SharePoint admin center, navigate to Policies > Sharing, and ensure that external sharing is enabled and configured to allow guests to use desktop applications.
Review Desktop App Access Policies and Use Web Workaround
If organizational policies restrict opening files in desktop applications for external users, use Excel for the Web as an immediate workaround.
Edit Spreadsheets Without Complex Tenant Subscriptions Using WPS Office
Avoid complex guest access policies, Entra ID configurations, and licensing issues. WPS Office is a lightweight, free Microsoft Office alternative that allows you to easily edit spreadsheets offline or share them via cloud without worrying about strict tenant access restrictions.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install and Launch: Follow the on-screen instructions to install the software, then open WPS Spreadsheets.
- 3. Edit Excel Files Seamlessly: Open your .xlsx files directly in WPS Office to start editing locally without online tenant restrictions.
Frequently Asked Questions
Why can I open the SharePoint Excel file in my browser but not the desktop app?
Desktop app access requires the external user's account to be properly licensed and authenticated in the host's directory. Additionally, the tenant's security policies must explicitly allow desktop app access for guests.
Does a guest user need a Microsoft 365 license to open shared files in the Excel desktop app?
Yes, typically editing files in the Excel desktop app requires the guest user to have their own valid Microsoft 365 subscription, whereas web-based editing is often free for external guests.
Can I fix this external sharing issue without contacting the IT admin?
Usually not. Modifying guest access permissions, Conditional Access rules, and external sharing policies requires administrative privileges in the host organization's Microsoft 365 tenant.
