Permission & Access Issues

How to Allow Online Editing Without Downloading in SharePoint

Natalie TaylorNatalie Taylor Nov 3, 2026 868 views

Question details

The user needs to allow collaborators to edit a large Excel file online in SharePoint without granting them permission to download, delete, or open the file in the desktop application.

How to Allow Online Editing Without Downloading in SharePoint Excel
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Sharing a large Excel file securely in SharePoint for collaborative editing while restricting data exfiltration or accidental deletion.
Observed behavior
SharePoint does not provide a default permission level that supports online-only editing while explicitly blocking file downloads, desktop application opening, and item deletion.
Before you start

Ensure you are logged in with a Site Collection Administrator account or have Full Control permissions on the SharePoint site to create and assign custom permission levels.

Solution 1Recommended

Create a Custom SharePoint Permission Level

Build a specialized permission level based on existing edit rights, retaining browser-based editing capabilities but stripping away the ability to download or open the file locally.

Since SharePoint does not include an out-of-the-box permission level for this exact scenario, the best approach is to copy an existing permission level like 'Contribute' or 'Edit' and remove the specific rights that allow data extraction.

1
Access Site Settings

Log in to your SharePoint site, click the gear icon in the top right corner, and select 'Site information' followed by 'View all site settings'.

2
Navigate to Permission Levels

Under the 'Users and Permissions' section, click on 'Site permissions'. Then, click on 'Permission Levels' located in the top ribbon.

3
Copy an Existing Permission Level

Click on the 'Contribute' or 'Edit' permission level. Scroll all the way to the bottom of the permission list and click the 'Copy Permission Level' button.

4
Customize the New Permission

Provide a name for the new level (e.g., 'Online Edit Only'). In the List Permissions section, uncheck the boxes for 'Delete Items', 'Delete Versions', and 'Open Items' (which allows opening documents in client applications and downloading).

5
Save and Assign

Click 'Create' at the bottom to save. Navigate back to your document library, break permission inheritance for the specific Excel file if necessary, and assign this new permission level to the target users.

Create a Custom SharePoint Permission Level
Testing is Crucial: Always test the newly created custom permission level using a standard, non-administrative user account to verify that the download button is hidden and desktop editing is successfully blocked.
Free Microsoft Office alternative

Edit and Manage Large Excel Files Smoothly with WPS Office

If managing complex SharePoint permissions and handling large Excel files online is slowing down your workflow, consider using WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office, complete with secure cloud collaboration features.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your large Excel files seamlessly with full formatting preserved.
  3. 3. Share Securely: Upload the file to WPS Cloud and generate a secure sharing link with customized view or edit permissions.
Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight design ensures large spreadsheets open and calculate smoothly without browser lag.Free and easy to use with a familiar tabbed user interface.Secure file sharing and robust link permission controls via WPS Cloud.
microsoft office alternative - wps office

Frequently Asked Questions

Can I block downloads for specific files only in a SharePoint library?

Yes. You can break permission inheritance for a specific file or folder. Once inheritance is broken, you can assign your custom 'Online Edit Only' permission level specifically to that file, leaving the rest of the document library unaffected.

Why do users still see the 'Open in Desktop App' option?

If users still see this option, ensure that the 'Open Items' permission is unchecked in your custom permission level. Additionally, verify that the user does not have higher permission levels granted through another SharePoint group or administrative role.

Does blocking downloads in SharePoint also prevent printing the Excel file?

Yes. When the 'Open Items' and download capabilities are restricted in SharePoint or OneDrive, printing to a PDF or physical printer via the browser interface is usually disabled automatically to prevent data leakage.

Will restricting desktop app access affect Excel co-authoring?

No, multiple users can still co-author and edit the Excel file simultaneously using Excel for the Web in their browsers. The restriction only prevents them from pulling the file down to their local desktop environment.