How to Allow Online Editing Without Downloading in SharePoint
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.

- 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.
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.
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.
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'.
Under the 'Users and Permissions' section, click on 'Site permissions'. Then, click on 'Permission Levels' located in the top ribbon.
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.
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).
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.

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. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your large Excel files seamlessly with full formatting preserved.
- 3. Share Securely: Upload the file to WPS Cloud and generate a secure sharing link with customized view or edit permissions.

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.




