How to Open SharePoint Excel Hyperlinks Without Allowing Downloads
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.

- 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.
Ensure you have the necessary owner or administrator permissions in your SharePoint or OneDrive environment to manage sharing links and modify access controls.
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.
Navigate to the Excel workbook in your SharePoint document library or OneDrive folder.
Click the 'Share' icon next to the file name, or right-click the file and select 'Share' from the context menu.
Click on the current sharing permissions (usually displaying 'Anyone with the link' or 'People in your organization') to open the Link settings.
Under 'More settings', ensure the permission dropdown is set to 'Can view' so users cannot edit the file.
Toggle the 'Block download' switch to the ON position and click 'Apply' to generate the restricted link.

Combine with Unlocked Ranges for Specific Interactions
If you need to allow users to interact with specific cells while restricting the rest, combine restricted sharing with Excel's sheet protection.
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. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open your Workbook: Launch WPS Spreadsheets and open your existing .xlsx files with complete format compatibility.
- 3. Manage Sheet Protection: Navigate to the Review tab to easily configure cell locking and sheet protection features.

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.




