'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Share SharePoint Excel Files with Editing Allowed but Downloads Blocked
Question details
The user needs to share an Excel file via SharePoint so collaborators can edit the workbook online, while preventing them from downloading the file. Additionally, certain cells within the workbook need to remain protected.
- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Sharing a protected workbook for online collaboration without allowing users to save offline copies to their devices.
- Observed behavior
- When standard block download permissions are applied, the shared workbook often defaults to read-only mode, preventing users from making necessary edits online.
Ensure you have Site Owner or Full Control permissions in your SharePoint environment so you can modify folder inheritance and assign custom permission levels.
Apply "Edit Without Download" Permission at the Folder Level
Creating a dedicated folder with specific custom permissions ensures multiple Excel files inherit the correct access rights, allowing online editing while blocking downloads.
Applying specialized permissions to an entire folder is highly recommended over configuring individual files. This approach prevents sharing link conflicts and makes managing access for multiple Excel files significantly easier.
Navigate to your SharePoint site document library. Create a new folder, select it, and click on 'Manage Access'. Go to the 'Advanced' settings and click 'Stop Inheriting Permissions'.
Grant the target users or groups the specific 'Edit without download' custom permission level for this newly created folder.
Select the existing Excel files you intend to share. Go to their individual access settings and delete any existing sharing links to prevent conflicting permissions.
Move the Excel files into the configured folder so they automatically inherit its permissions. Open each file in the Excel desktop app, go to the 'Review' tab, and use 'Protect Sheet' to lock specific worksheet cells before users access them online.
Easily Share and Protect Spreadsheets with WPS Office
WPS Office provides seamless cloud collaboration through WPS Cloud. You can easily share your spreadsheets for online co-editing, restrict download capabilities, and protect specific cells, all within a single intuitive interface.
- 1. Save to WPS Cloud: Open your spreadsheet in WPS Office and save it directly to your WPS Cloud drive.
- 2. Protect Specific Cells: Navigate to the 'Review' tab, select 'Protect Sheet', and set a password to securely lock the designated cells.
- 3. Create a Sharing Link: Click the 'Share' button located in the top right corner of the WPS Office interface.
- 4. Set Link Permissions: Choose the option 'Anyone with the link can Edit'. Under the advanced security settings, disable the 'Allow Download' toggle to prevent offline copies.
Frequently Asked Questions
Why does blocking downloads make my SharePoint Excel file read-only?
In SharePoint's default permission structure, the 'Block Download' feature is typically tied to 'View Only' access. To allow editing without downloading, a custom permission level specifically designed for 'Edit without download' must be configured and assigned by an administrator.
Can I apply the 'Edit without download' permission to individual files instead of folders?
Yes, you can apply it to individual files by stopping permission inheritance at the file level. However, managing custom permissions per file is prone to errors and conflicts, which is why configuring a dedicated folder and letting files inherit those permissions is recommended.
Will users still be able to modify protected cells if they have Edit access?
No. If you lock and protect specific cells in the Excel desktop application using 'Protect Sheet' before sharing, users will be unable to modify those designated cells in the online viewer, regardless of their editing permissions.
Can users print the Excel file if downloads are blocked?
Generally, no. Applying 'Edit without download' or similar restrictive permissions typically disables the printing functionality within the web browser interface to prevent users from easily extracting the data.
