How to Open Hyperlinks in Locked Cells on a Protected Excel Sheet
Question details
Users are unable to open or click hyperlinks located inside locked cells on a protected Excel worksheet.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Interacting with hyperlinks within a protected spreadsheet where certain cells are locked to prevent editing.
- Observed behavior
- The hyperlinks in locked cells do not respond or cannot be clicked when the worksheet protection is active.
Ensure that you have the password to unprotect the worksheet if it was previously protected by another user.
Enable 'Select Locked Cells' During Protection
Adjust the sheet protection settings to allow users to select locked cells, which restores the ability to click hyperlinks.
When a worksheet is protected, Excel restricts certain actions based on your settings. If the ability to select locked cells is disabled, any hyperlinks contained within those cells become unclickable. Modifying the protection rules will solve this issue without compromising the locked status of your data.
Go to the 'Review' tab on the ribbon and click 'Unprotect Sheet'. If the sheet is password-protected, enter the password to temporarily remove the protection.
Still under the 'Review' tab, click on 'Protect Sheet' to open the protection settings dialog box.
In the 'Protect Sheet' dialog box, look under the 'Allow all users of this worksheet to:' list. Ensure the box next to 'Select locked cells' is checked.
Enter a password if desired, click 'OK', and then try clicking the hyperlink in the locked cell to verify it opens correctly.
Protect Sheets and Keep Hyperlinks Active with WPS Office
WPS Spreadsheet allows you to seamlessly protect your data while maintaining the functionality of your hyperlinks. You can easily configure user permissions to select locked cells with just a few clicks.
- 1. Open your file: Launch WPS Spreadsheet and open your document containing the hyperlinks.
- 2. Access protection settings: Navigate to the 'Review' tab on the top menu ribbon and click on 'Protect Sheet'.
- 3. Adjust permissions: In the pop-up window, check the box for 'Select locked cells' so users can interact with the links.
- 4. Apply protection: Enter a password to secure your sheet and click 'OK'. Your hyperlinks are now protected but fully clickable.
Frequently Asked Questions
Can I allow users to click a hyperlink without letting them select the cell?
No, in standard spreadsheet protection, a user must be able to select the cell to trigger the hyperlink. Allowing the 'Select locked cells' option is required for the hyperlink to function.
Why do my hyperlinks work in unprotected sheets but break when protected?
When a sheet is protected without allowing users to select locked cells, the cell becomes completely inactive to cursor clicks. This security measure inadvertently prevents the embedded hyperlink from firing.
How do I protect only specific cells while leaving hyperlinks editable?
Select the cells containing the hyperlinks, right-click, and choose 'Format Cells'. Go to the 'Protection' tab and uncheck 'Locked'. When you protect the sheet afterward, those specific hyperlink cells will remain fully accessible and editable.
