How to Allow SharePoint Browser Editing but Block Desktop App Editing
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.

- 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.
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.
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.
Navigate to Site settings > Site collection features and activate the 'Limited-access user permission lockdown mode' feature.
Remove the target user's existing permissions from the SharePoint site and the specific document library to prevent standard navigation access.
Go to the specific Excel file in your library, open 'Manage Access', click on 'Advanced', and select 'Stop Inheriting Permissions' from the ribbon.
Click 'Grant Permissions' and assign the user 'Edit' permission directly to this single file.
Because the user no longer has general site access, provide them with the direct URL to open the file in their web browser.

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. Download and Install: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Existing Files: Launch WPS Office and open your existing .xlsx, .docx, or .pptx files directly with full compatibility.
- 3. Share and Collaborate: Use WPS Cloud to securely share documents and manage access via easy-to-use link permissions.

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.




