Permission & Access Issues

How to Allow SharePoint Browser Editing but Block Desktop App Editing

Natalie TaylorNatalie Taylor Oct 21, 2026 869 views

Question details

The user wants to permit Excel file editing in the SharePoint web browser interface while restricting the file to read-only in the desktop application.

How to Allow SharePoint Browser Editing but Block Desktop App Editing
Product
Microsoft SharePoint / Excel
Device & OS
not provided
Scenario
Managing document permissions in a SharePoint library for restricted access control.
Observed behavior
Standard SharePoint permissions do not natively offer a straightforward setting to split browser editing and desktop app editing rights.
Before you start

Verify whether this permission requirement applies to a single specific file or an entire document library, as this workaround will affect the user's general site access. You will also need Site Owner or Full Control rights to change permission inheritance and site collection features.

Solution 1Recommended

Restrict Desktop Access via Limited-Access Lockdown Mode

Use a combination of site collection features and unique file permissions to force browser-only editing.

Standard customized permissions cannot cleanly separate web app editing from desktop app editing. This workaround involves locking down the user's broader site access so they can only interact with the specific file via a direct link.

1
Enable Lockdown Mode

Navigate to Site settings > Site collection features and activate the 'Limited-access user permission lockdown mode' feature.

2
Remove Site and Library Permissions

Remove the target user's existing permissions from the SharePoint site and the specific document library to prevent standard navigation access.

3
Stop Permission Inheritance

Go to the specific Excel file in your library, open 'Manage Access', click on 'Advanced', and select 'Stop Inheriting Permissions' from the ribbon.

4
Grant Unique Edit Permissions

Click 'Grant Permissions' and assign the user 'Edit' permission directly to this single file.

5
Share Direct Link

Because the user no longer has general site access, provide them with the direct URL to open the file in their web browser.

Restrict Desktop Access via Limited-Access Lockdown Mode
Site Access Limitation: Using this method means the user will lose normal navigation access to the SharePoint site and must access the file strictly via the provided direct URL.
Free Microsoft Office alternative

Try WPS Office for Your Document Needs

If you're looking for a simpler way to manage your spreadsheets, documents, and presentations without complex permission setups, WPS Office offers a lightweight, free alternative to Microsoft Office. It provides comprehensive compatibility with Microsoft file formats and an intuitive interface.

  1. 1. Download and Install: Visit the official WPS website and download the free WPS Office suite for your operating system.
  2. 2. Open Existing Files: Launch WPS Office and open your existing .xlsx, .docx, or .pptx files directly with full compatibility.
  3. 3. Share and Collaborate: Use WPS Cloud to securely share documents and manage access via easy-to-use link permissions.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight installation and smooth performance on all hardware.Built-in cloud collaboration and file sharing options for easy document management.Familiar tabbed interface makes switching from Microsoft Office seamless.
microsoft office alternative - wps office

Frequently Asked Questions

Can I block desktop editing for an entire SharePoint library?

Blocking desktop editing while allowing browser editing for an entire library is difficult because standard SharePoint permission levels don't natively split web and desktop edit rights. The lockdown workaround is best suited for individual files rather than an entire library.

Why does the user lose site access when using the lockdown workaround?

To prevent the user from opening the file in the desktop app via normal library navigation, their general library and site permissions must be removed. They are granted unique permissions only on the file itself, which isolates their access and requires a direct URL.

Is there a built-in permission level to force web-only editing?

No, Microsoft SharePoint does not currently offer a standard permission level out-of-the-box that allows editing exclusively in SharePoint Online (web browser) while enforcing read-only access in the local desktop application.

Will Conditional Access policies help restrict desktop apps?

Yes, if you have Microsoft Entra ID Premium, administrators can configure Conditional Access policies and Microsoft Defender for Cloud Apps to enforce session controls that block desktop app access while allowing web browser sessions.