SharePoint Document Issues

How to Allow Excel Editing Only in the Desktop App on SharePoint

Adam DavisAdam Davis Oct 23, 2026 869 views

Question details

The user needs a way to force a macro-enabled Excel workbook hosted on SharePoint to be editable exclusively in the desktop application, keeping it read-only in Excel for the Web.

How to Allow Excel Editing Only in the Desktop App on SharePoint
Product
SharePoint and Microsoft Excel
Device & OS
not provided
Scenario
Managing user editing permissions for complex or macro-enabled Excel workbooks shared via a SharePoint document library.
Observed behavior
Currently, users can open and attempt to edit the file in the browser (Excel for the Web), which is undesired. The goal is to restrict editing to the desktop application only.
Before you start

Ensure you have Site Owner or Library Administrator permissions in SharePoint, as you will need to modify the versioning and checkout settings of the document library.

Solution 1Recommended

Enforce Document Checkout in SharePoint Library Settings

The most reliable method to prevent browser-based editing is to require document checkout. This forces users to open the file in the desktop application to make changes.

By requiring documents to be checked out, users who open the file in Excel for the Web will only be granted read-only access. To edit the workbook, they must explicitly check it out and launch the desktop application.

Please note that enforcing checkout locks the file to a single user, which means simultaneous co-authoring will no longer be possible for this library.

1
Access Library Settings

Navigate to the specific SharePoint document library. Click on the 'Settings' gear icon in the top right corner of the screen, and select 'Library settings'.

2
Open Versioning Settings

In the library settings panel, click on 'More library settings' to open the advanced options. Under the 'General Settings' column, click on 'Versioning settings'.

3
Enable Checkout Requirement

Scroll down to the bottom of the page to find the 'Require Check Out' section. Select the 'Yes' radio button under 'Require documents to be checked out before they can be edited'.

4
Save Configuration

Click the 'OK' button at the bottom right to save your changes. The library will now force desktop app editing via checkout.

Enforce Document Checkout in SharePoint Library Settings
Configuration Complete: Browser access will now remain read-only. Users will be prompted to check out the file and open the desktop app to perform any edits.
Free Microsoft Office alternative

Manage Complex Spreadsheets Easily with WPS Office

If your team frequently works with complex, macro-enabled spreadsheets that struggle in web environments, WPS Office provides a powerful, lightweight, and free desktop alternative to handle your offline data editing needs effortlessly.

  1. 1. Download WPS Office: Visit the official WPS website to download and install WPS Office Free on your computer.
  2. 2. Download File Locally: Download your target spreadsheet from your SharePoint library to your local hard drive.
  3. 3. Edit Seamlessly: Open WPS Spreadsheets, navigate to your downloaded file, and complete your edits locally before re-uploading the updated file to SharePoint.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvLightweight desktop application that handles large datasets quicklyFamiliar ribbon interface ensures zero learning curve for seamless migrationCompletely free to download with rich built-in template libraries
microsoft office alternative - wps office

Frequently Asked Questions

Will requiring checkout in SharePoint prevent simultaneous co-authoring?

Yes. When the 'Require Check Out' setting is enabled, a document is locked to the specific user who checks it out. This means other users cannot edit the file simultaneously, effectively disabling co-authoring until the file is checked back in.

Is there a way to strictly disable the 'Open in browser' button in SharePoint?

There is no native, reliable way to completely remove or disable the 'Open in browser' option for users in SharePoint. Setting the default behavior to 'Open in the client application' changes the default action, but enforcing checkout is the only way to make the browser view strictly read-only.

Why do my Excel macros fail when opened in SharePoint via the web?

Excel for the Web does not support VBA (Visual Basic for Applications) macros. If a user opens a macro-enabled workbook (.xlsm) in the browser, they can view the data, but the macros will not run. To use the macros, the file must be opened in a desktop client.

Can I apply the checkout requirement to just one specific Excel file?

No, the 'Require Check Out' feature in SharePoint is applied at the library level, meaning it affects all documents within that specific library. If you need this restriction for only one file, you should create a separate document library with these settings and move the file there.