SharePoint Document Issues

Fix Inconsistent Excel File Opening in SharePoint Server 2016

Khadija KhanKhadija Khan Oct 9, 2026 870 views

Question details

Users experience inconsistent browser behaviors when attempting to open the same Excel spreadsheet from a local SharePoint server.

How to Fix Inconsistent Excel File Opening in SharePoint Server 2016
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.
Before you start

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.

Solution 1Recommended

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.

1
Visit Microsoft Q&A

Navigate to the official Microsoft Q&A platform using your web browser.

2
Search for Relevant Tags

Filter your search using the 'SharePoint Server Management' or 'SharePoint Server' tags to find the on-premises support channels.

3
Post Your Issue

Create a new thread detailing your exact server version, Edge browser versions, and the inconsistent Excel opening behavior to get assistance from server experts.

Consult the SharePoint Server Management Community
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to complete the setup.
  3. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Lightweight installation ensures downloaded files open instantly without server delays.Familiar spreadsheet interface requires no learning curve for new users.Free to use with comprehensive data analysis and formatting tools.
QA img-9

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.