Fix SharePoint Files Opening in Browser but Not in Office Apps
Question details
Users are unable to open SharePoint files in local Office desktop applications despite being able to view and edit them in a web browser.
- Product
- Microsoft SharePoint / Microsoft Office
- Device & OS
- not provided
- Scenario
- Attempting to open a SharePoint file directly in a local Office desktop application (like PowerPoint or Word) instead of using the web-based editor.
- Observed behavior
- The file successfully opens and remains editable in the web browser, but it refuses to open or prompts an error when launched in the associated Office desktop application.
Ensure you are logged into your local Office desktop applications using the exact same Microsoft 365 work or school account that you use to access the SharePoint site.
Verify Microsoft 365 Licensing and Permissions
Check if your Microsoft 365 account actually includes the license required to use the desktop versions of Office applications.
Many organizations assign Microsoft 365 basic licenses that only permit users to edit documents via 'Office on the web'. To open files locally, your account must explicitly have a license for desktop applications.
Go to the Microsoft 365 web portal and sign in with your work or school account credentials.
Click on your profile picture or initials in the top right corner of the screen and select 'View account'.
In the left-hand navigation pane, click on 'Subscriptions' to view the specific licenses assigned to your account.
Check the list for 'The latest desktop version of Office'. If this is missing, you only have web access. You must contact your company's IT administrator to request a license upgrade.
Sign Out and Reconnect Your Office Account
Clear cached credentials that might be preventing the Office desktop app from recognizing your SharePoint permissions.
Use WPS Office to Edit Your Downloaded Files for Free
If you lack the required Microsoft 365 desktop license to open SharePoint files locally, you can download the files to your computer and edit them for free using WPS Office. It is a lightweight, highly compatible alternative that requires no expensive subscriptions.
- 1. Download the file from SharePoint: In your web browser, select the file in SharePoint, click 'Download' from the top menu, and save it to your local hard drive.
- 2. Install WPS Office: Download and install WPS Office for free from the official WPS website.
- 3. Open and edit locally: Launch WPS Office and open your downloaded file. You can now edit the document locally with full formatting capabilities.
Frequently Asked Questions
Why can I edit a file online but not in the desktop app?
This commonly occurs when your Microsoft 365 subscription plan (like Microsoft 365 Business Basic) only includes 'Office on the web'. Desktop editing requires a premium license that includes the desktop versions of Word, Excel, and PowerPoint.
How do I force a SharePoint file to open in the desktop app by default?
If you have the correct desktop licenses, a site administrator can change the default behavior. They must go to Library Settings > Advanced Settings, locate 'Opening Documents in the Browser', and select 'Open in the client application'.
Can cached browser data cause SharePoint files to fail when opening locally?
Yes, sometimes corrupted browser cache or outdated login tokens can interrupt the handoff between the web browser and the desktop app. Clearing your browser's cache and cookies, or trying an Incognito/Private window, can help resolve the issue.
