Permission & Access Issues

How to Edit SharePoint Excel Files Without Allowing Downloads

Huda Qurayshi Sep 28, 2026 869 views

Question details

The user wants to configure SharePoint permissions so that users can edit an Excel file and save a copy, while strictly preventing them from downloading the original file.

Edit SharePoint Excel Files Without Allowing Downloads

Product: Microsoft SharePoint / Excel
Device & OS: not provided
Scenario: Configuring file access and editing permissions for a shared Excel document in a SharePoint environment.
Observed behavior: The standard SharePoint permission architecture does not reliably combine download prevention with the ability to create and save a separate copy of the file.

Before you start

Verify that you have Site Owner or Full Control permissions in your SharePoint environment, as modifying permission levels requires administrative access.

Solution 1Recommended

Configure Edit Access While Restricting Downloads

While you cannot allow users to save a copy without download permissions, you can create a custom permission level in SharePoint to let them edit the file online without downloading the original.

SharePoint cannot reliably combine download prevention with the ability to save a copy using standard permission levels. Creating and saving a separate copy intrinsically requires download or equivalent file-creation permissions. However, you can configure users to edit the file directly in the browser without allowing them to download the source file.

Access Site Permissions

Navigate to your SharePoint site. Click the gear icon in the top right corner to open 'Site settings', and then select 'Site permissions' under the Users and Permissions section.

Open Permission Levels

In the Site Permissions ribbon, click on the 'Permission Levels' button to view the list of available permission configurations for your site.

Copy an Existing Permission Level

Click on the standard 'Contribute' or 'Edit' permission level. Scroll to the bottom of the page and click the 'Copy Permission Level' button to use it as a template.

Customize the New Permission Level

Give the new permission level a name, such as 'Edit Without Download'. Look through the list of permissions and uncheck the 'Open Items' option (which controls the ability to view the source or download documents). Keep 'Edit Items' checked.

Assign the Custom Permission

Save the new permission level. Return to your document library settings, stop inheriting permissions if necessary, and assign this new 'Edit Without Download' level to the targeted users or groups.

Configure Edit Access While Restricting Downloads

Limitation Warning: Keep in mind that while users can edit the document using Excel for the Web with this setup, this configuration restricts their ability to use 'Save As' to create a separate copy, as that action requires download permissions.

Free Microsoft Office alternative

Manage Spreadsheets Easily with WPS Office

Since SharePoint restricts combining edit access with download prevention for saving copies, managing complex file permissions can be challenging. WPS Office provides a flexible, lightweight, and highly compatible alternative to Microsoft Office, giving you full control over your local and cloud spreadsheet workflows.

1. Visit the WPS Office Website: Go to the official WPS Office website on your computer.
2. Download the Installer: Click the 'Free Download' button to get the correct version for your operating system.
3. Install and Edit: Run the installer to set up WPS Office, then open your Excel files to start editing instantly.

Highly compatible with Microsoft Excel formats (.xlsx, .xls) for seamless file sharing.Free and lightweight alternative to Microsoft Office with a familiar user interface.Advanced document encryption and password protection settings for local files.Built-in PDF conversion and collaborative spreadsheet tools.

microsoft office alternative - wps office

Frequently Asked Questions

Can I block downloads but allow users to use the 'Save As' feature in SharePoint?

No, SharePoint cannot reliably combine download prevention with the ability to save a copy. Using the 'Save As' function or creating a separate copy requires download or equivalent file-creation permissions.

Does the 'Block Download' sharing link allow editing?

By default, the 'Block download' feature in standard SharePoint sharing links is restricted to 'View only' mode. If you enable editing on a sharing link, the 'Block download' option typically becomes unavailable.

Why do users need download permissions to save a copy of an Excel file?

Saving a copy essentially involves extracting the file data to create a new file. In SharePoint's underlying permission architecture, this action is treated similarly to downloading the source file, meaning standard permission levels require download rights to execute this task.

Document & File Issues