How to Protect an Excel Workbook While Keeping Hyperlinks Active
Question details
The user needs to share an Excel workbook in read-only mode or protect it from edits, while ensuring that embedded hyperlinks remain clickable and functional for other users.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Distributing a locked or read-only spreadsheet where users still need to navigate to external links or attached documents.
- Observed behavior
- Standard worksheet protection or strict Information Rights Management (IRM) policies often block users from clicking external links or accessing linked resources.
Verify that all hyperlinks in your document are correctly configured and pointing to active destinations before applying any worksheet protection.
Unlock Hyperlink Cells Before Protecting the Worksheet
By specifically formatting your hyperlink cells as "Unlocked" before applying worksheet protection, you ensure that users can still click and interact with them while the rest of the sheet remains read-only.
In Excel, all cells are locked by default, but this lock only takes effect once worksheet protection is turned on. To keep hyperlinks active, you must exempt them from this global lock.
Highlight all the cells that contain the hyperlinks you want to keep active.
Right-click the selected cells and choose 'Format Cells' from the context menu.
Navigate to the 'Protection' tab in the Format Cells dialog. Uncheck the 'Locked' box and click 'OK'.
Go to the 'Review' tab on the top ribbon and click 'Protect Sheet'. Make sure the option 'Select unlocked cells' is checked. Enter a password if desired, then click 'OK' to apply the protection.

Use Read-Only Recommended Settings Instead of IRM
Information Rights Management (IRM) can sometimes forcefully block external link access. Using standard Read-Only file sharing bypasses this issue and keeps links functional.
Easily Protect Workbooks and Preserve Links in WPS Office
WPS Spreadsheet provides a straightforward and highly intuitive way to protect your sheets from unwanted edits while keeping vital hyperlinks fully clickable. Best of all, it seamlessly handles Microsoft Excel formats.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the hyperlinks.
- 2. Unlock specific cells: Select the cells with hyperlinks, right-click to choose 'Format Cells', and uncheck 'Locked' under the Protection tab.
- 3. Apply sheet protection: Navigate to the 'Review' tab on the top ribbon and click 'Protect Sheet'.
- 4. Configure permissions: Ensure 'Select unlocked cells' is permitted, set an optional password, and confirm to lock the sheet while keeping links active.

Frequently Asked Questions
Why are my hyperlinks not working after protecting the Excel sheet?
By default, all cells in an Excel sheet are formatted as 'Locked'. When you turn on sheet protection, locked cells cannot be interacted with properly. You must explicitly unlock the specific hyperlink cells via the Format Cells menu before applying protection.
Can I allow users to click links without letting them edit the link text?
Yes. If you uncheck 'Locked' on the hyperlink cells but do not grant users formatting permissions in the 'Protect Sheet' dialog, they can click the link to open it, but they will not be able to easily alter the underlying formula or hyperlink destination without the protection password.
Does protecting the workbook structure affect my hyperlinks?
No, protecting the workbook structure (which prevents users from adding, deleting, hiding, or renaming sheets) does not affect the functionality of hyperlinks within the cells. You can safely apply workbook structure protection while keeping your links fully active.




