Permission & Access Issues

How to Open SharePoint Excel Hyperlinks Without Allowing Downloads

Amos GikundaAmos Gikunda Oct 9, 2026 870 views

Question details

The user wants to allow view-only users to click and open hyperlinks in a SharePoint Excel workbook in a new tab, but restrict them from downloading the actual workbook file.

How to Open SharePoint Workbook Hyperlinks Without Allowing Downloads
Product
Microsoft SharePoint / Excel
Device & OS
not provided
Scenario
Sharing an Excel workbook online while maintaining strict download restrictions but keeping embedded hyperlinks functional for users.
Observed behavior
Using Excel's built-in worksheet protection alone is insufficient because it does not remove the download option from the SharePoint or OneDrive interface.
Before you start

Ensure you have the necessary owner or administrator permissions in your SharePoint or OneDrive environment to manage sharing links and modify access controls.

Solution 1Recommended

Configure Restricted View with Block Download in SharePoint

Use SharePoint's built-in sharing settings to create a view-only link that explicitly blocks downloads while keeping hyperlinks active.

To prevent users from downloading the workbook while still allowing them to interact with hyperlinks, you must use the file-sharing permission settings in SharePoint or OneDrive rather than relying solely on Excel's sheet protection.

1
Locate the file

Navigate to the Excel workbook in your SharePoint document library or OneDrive folder.

2
Open sharing settings

Click the 'Share' icon next to the file name, or right-click the file and select 'Share' from the context menu.

3
Adjust link settings

Click on the current sharing permissions (usually displaying 'Anyone with the link' or 'People in your organization') to open the Link settings.

4
Set view permissions

Under 'More settings', ensure the permission dropdown is set to 'Can view' so users cannot edit the file.

5
Enable Block Download

Toggle the 'Block download' switch to the ON position and click 'Apply' to generate the restricted link.

Configure Restricted View with Block Download in SharePoint
Expected Behavior: Users accessing this link will view the workbook in Excel for the Web. They can click hyperlinks to open them in a new tab, but the download, print, and copy options will be entirely disabled.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you're looking for a cost-effective and highly compatible solution for managing complex spreadsheets and permissions, WPS Office offers a lightweight, free alternative to Microsoft Office. It fully supports standard Excel formats and provides intuitive document security features.

  1. 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
  2. 2. Open your Workbook: Launch WPS Spreadsheets and open your existing .xlsx files with complete format compatibility.
  3. 3. Manage Sheet Protection: Navigate to the Review tab to easily configure cell locking and sheet protection features.
100% compatible with Microsoft Excel (.xlsx) formats.Built-in document encryption and permission controls for local files.Free and lightweight alternative to Microsoft Office.Familiar user interface for a zero-learning-curve transition.
QA img-9

Frequently Asked Questions

Why does worksheet protection still allow users to download the file?

Worksheet protection only restricts editing within the file itself. It does not control file-level actions in SharePoint or OneDrive, such as downloading or copying the entire file. File-level restrictions must be set in the SharePoint sharing menu.

Can users copy data from a workbook if 'Block Download' is enabled?

No. When the 'Block download' feature is enabled in SharePoint or OneDrive, it automatically blocks users from printing or copying the text from the workbook to their device's clipboard.

Do hyperlinks work differently in Excel for the Web compared to the desktop app?

Yes, in Excel for the Web (which is the required viewer for restricted links), hyperlinks automatically open in a new browser tab to prevent users from navigating away from the original workbook view.