Open a SharePoint Excel Workbook in the Desktop Excel App
Question details
The user wants Excel workbooks opened from a SharePoint site to launch in the desktop Excel application rather than in the browser.

- 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.
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.
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.
Go to the SharePoint site, open the affected document library, select the Settings gear, and choose Library settings.
On the Library settings page, select Advanced settings.
Find Opening Documents in the Browser and select Open in the client application, then select OK or Save.
Return to the library and open the Excel workbook again. If prompted, select Open in Desktop App to launch the installed Excel application.

Open one workbook in the desktop app without changing library settings
Use this option when you only need to open a specific workbook in desktop Excel or cannot edit the SharePoint library configuration.
Ask the Microsoft 365 administrator to review organization-level policies
Use this method when the library setting is missing, changes do not take effect, or users are always redirected to Excel for the web.
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. 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. 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. 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.

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.




