SharePoint Document Issues

Open a SharePoint Excel Workbook in the Desktop Excel App

Natalie TaylorNatalie Taylor Nov 12, 2026 869 views

Question details

The user wants Excel workbooks opened from a SharePoint site to launch in the desktop Excel application rather than in the browser.

Open a SharePoint Excel Workbook in the Desktop Excel App
Product
Microsoft SharePoint document library and Microsoft Excel
Device & OS
not provided
Scenario
A user opens an Excel workbook stored in a SharePoint document library and prefers the desktop application workflow.
Observed behavior
The workbook opens in Excel for the web or does not launch in the expected desktop Excel application.
Before you start

You need Edit or Design-level permission for the SharePoint document library to change its opening behavior. If the library setting is unavailable or locked, contact your Microsoft 365 or SharePoint administrator because organization policies can override it.

Solution 1Recommended

Set the SharePoint document library to open files in the desktop app

Use this method when you manage the SharePoint library and want Office documents to open in their installed desktop applications by default.

This setting applies to the document library. After it is changed, supported Office files such as Excel workbooks should open in the desktop application for users who have that application installed and are signed in with the appropriate account.

1
Open the document library settings

Go to the SharePoint site, open the affected document library, select the Settings gear, and choose Library settings.

2
Open advanced library options

On the Library settings page, select Advanced settings.

3
Change the document opening preference

Find Opening Documents in the Browser and select Open in the client application, then select OK or Save.

4
Test the workbook

Return to the library and open the Excel workbook again. If prompted, select Open in Desktop App to launch the installed Excel application.

Set the SharePoint document library to open files in the desktop app
Desktop opening is enabled: When the client application option is available and allowed by your organization, SharePoint will prefer the desktop Office app over the browser.
Free Microsoft Office alternative

Open SharePoint Excel Files with WPS Office After Downloading or Syncing

If SharePoint or Microsoft 365 policies prevent the expected Excel desktop launch, WPS Office provides a free, lightweight alternative for opening and editing downloaded or synced Excel workbooks. Its familiar spreadsheet interface and strong format compatibility help you continue working without a complicated transition.

  1. 1. Download the SharePoint workbook: In SharePoint, select the workbook, open More options, and choose Download, or sync the library to your computer using the organization-approved sync method.
  2. 2. Open the file in WPS Spreadsheets: Open WPS Office, select Spreadsheets, and choose Open to browse to the downloaded or synced .xlsx or .xls workbook.
  3. 3. Edit and save the workbook: Make the needed changes in WPS Spreadsheets, then select Menu > Save or Save As to retain an Excel-compatible file format.
Open and edit Excel workbook files, including .xlsx and .xls formats.Use a familiar spreadsheet workspace for formulas, tables, charts, and data editing.Work with files downloaded from or synchronized through a SharePoint document library.Free, lightweight Office suite designed for an easy migration from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Where is the SharePoint setting that controls whether Excel files open in the browser?

Open the SharePoint document library, select Settings > Library settings > Advanced settings, and look for Opening Documents in the Browser. Choose Open in the client application when the option is available.

Why does my SharePoint workbook still open in Excel for the web after I changed the library setting?

A Microsoft 365 organization policy, browser setting, missing desktop Excel installation, or account sign-in issue can override the library preference. Ask your Microsoft 365 administrator to review the applicable policies.

Can I open just one SharePoint Excel file in the desktop application?

Yes. Select the workbook in the library, open the three-dot More options menu, and choose Open in app or Open in Desktop App. The wording varies by SharePoint configuration.

Do all users need desktop Excel installed for the client application option to work?

Yes. Each user needs a supported desktop Excel installation and access rights to the SharePoint file. Otherwise, SharePoint may open the workbook in the browser.

Can WPS Office open an Excel workbook downloaded from SharePoint?

Yes. Download the .xlsx or .xls file from SharePoint, then open it through WPS Spreadsheets using Open. Save the edited file in Excel-compatible .xlsx format if it will be uploaded back to SharePoint.