How to Open Office Spreadsheets Directly in Microsoft Edge
Question details
The user wants to open Office spreadsheets directly within the web browser instead of having them download automatically.
- Product
- Microsoft Edge, SharePoint, OneDrive for Business
- Device & OS
- not provided
- Scenario
- Attempting to view or edit an online Office spreadsheet via a web browser.
- Observed behavior
- Office files are automatically downloaded to the local computer even when browser settings are configured to open them online.
Make sure your Microsoft Edge browser is updated to the latest version and verify that your spreadsheets are hosted on OneDrive for Business or SharePoint.
Enable Office files to open in Microsoft Edge
Use this solution to ensure your local Edge browser settings allow Office files to be rendered in the browser natively.
Microsoft Edge has a built-in feature designed to open Office files directly in the browser instead of triggering a download. Sometimes this setting is disabled by default or turned off accidentally.
Launch Microsoft Edge, type edge://settings/downloads in the address bar, and press Enter.
Locate the setting named 'Open Office files in the browser' and toggle the switch to the 'On' position.
Restart your browser and click on an Office spreadsheet link to verify it opens directly in the web viewer.
Configure SharePoint Document Library settings
Use this solution if the issue is specific to files hosted on a SharePoint site, as library configurations can override browser behaviors.
Deactivate 'Open in Client Application' Site Feature
Use this method if all document libraries across an entire SharePoint site are automatically downloading or launching files externally.
Use WPS Office as a Lightweight Alternative
If browser compatibility issues prevent you from viewing Office files online smoothly, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office, ensuring you can open, edit, and save your spreadsheets instantly without relying on complex browser configurations.
- 1. Download the software: Visit the official WPS website and download the free installation package.
- 2. Install WPS Office: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open your spreadsheets: Double-click any downloaded .xlsx or .xls file to open it instantly in the WPS Office desktop app.
Frequently Asked Questions
Why do my Excel files download from SharePoint instead of opening online?
This usually happens if the SharePoint library's default behavior is set to open files in the client application rather than the browser, or if the specific browser lacks the configuration to view Office files online.
Does this issue affect Google Chrome as well as Edge?
Yes, Chrome can also download files automatically. To fix this, you may need to install the Office extension for Chrome or adjust site settings to force files to open in the browser.
Can I force a specific document to open in the browser manually without changing settings?
Yes. In OneDrive for Business or SharePoint, you can hover over the file, click the three vertical dots (ellipses) next to the file name, and select 'Open' followed by 'Open in browser'.
