Fix Inconsistent Excel File Opening in SharePoint Server 2016
Question details
Users experience inconsistent browser behaviors when attempting to open the same Excel spreadsheet from a local SharePoint server.

- Product
- SharePoint Server 2016 On-Premises, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Users are attempting to open Excel files stored on a SharePoint Server 2016 On-Premises environment using the Microsoft Edge browser.
- Observed behavior
- Some users are prompted to open a copy of the Excel file, while others experience a direct browser download, despite having identical Microsoft Edge settings.
Verify that all users are running the exact same version of the Microsoft Edge browser and check if an Office Online Server (OOS) is configured for your SharePoint farm.
Consult the SharePoint Server Management Community
Since the issue is specific to SharePoint Server 2016 on-premises, reaching out to specialized server administrators is the most effective troubleshooting step.
SharePoint Server 2016 on-premises relies on local server configurations, IIS settings, and Office Online Server integrations that differ significantly from SharePoint Online. Expert administrators in the Microsoft Q&A community can help diagnose server-side behaviors and Edge browser policies.
Navigate to the official Microsoft Q&A platform using your web browser.
Filter your search using the 'SharePoint Server Management' or 'SharePoint Server' tags to find the on-premises support channels.
Create a new thread detailing your exact server version, Edge browser versions, and the inconsistent Excel opening behavior to get assistance from server experts.

Verify Document Library Default Open Behavior
Ensure that the document library is configured consistently for how it handles browser file requests.
Use WPS Office to Open and Edit Your Downloaded Spreadsheets
If you are dealing with complex SharePoint Server issues and users are downloading Excel files locally, WPS Office provides a lightweight, free, and highly compatible alternative to Microsoft Office for seamless spreadsheet management.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
- 2. Install the Software: Run the installer and follow the on-screen instructions to complete the setup.
- 3. Set as Default: Right-click any downloaded Excel (.xlsx) file, select 'Open with', choose WPS Office, and check 'Always use this app' to set it as your default spreadsheet viewer.

Frequently Asked Questions
Why do some Excel files download directly instead of opening in SharePoint?
This can happen if the browser's Office file handling settings differ among users, or if the SharePoint farm lacks an Office Online Server connection to render the files natively in the browser.
Can Edge settings override SharePoint's default open behavior?
Yes, Microsoft Edge's internal download settings and Office file integrations can intercept the SharePoint server's prompt, forcing a local download instead of launching the client application.
Is SharePoint Server 2016 supported the same way as SharePoint Online?
No, SharePoint Server 2016 is an on-premises product and relies on your local IT environment and server configurations, whereas SharePoint Online is cloud-hosted and managed directly by Microsoft.




