Create a Dynamic Hyperlink for an Excel Object Without VBA
Question details
The user wants an Excel object to open a dynamic hyperlink from a linked cell without using VBA.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An object displays the value of a cell containing a HYPERLINK formula, and the user wants to click the object to open the formula's destination.
- Observed behavior
- The hyperlink works when the worksheet cell is clicked, but clicking the linked object does not open the destination.
Identify the cell containing the HYPERLINK formula and check that its destination opens when you click the cell. If the destination comes from another cell, confirm that the source contains a valid URL or path.
Use the Dynamic Hyperlink Directly in a Worksheet Cell
Use the formula cell as the clickable link when you need a dynamic destination without VBA.
An Excel object linked to a cell can display the cell's value, but it does not generally inherit the clickable behavior of a HYPERLINK formula. Using the cell itself avoids that limitation.
In the worksheet, enter the destination URL in a cell such as A2. For example, enter https://example.com.
Select the cell you want users to click and enter =HYPERLINK(A2,"Open link"). Press Enter to display the link text.
Click the formula cell to open the destination. Use the Home tab to adjust its font, fill, borders, or alignment so it is easy to identify.
Change the URL in A2 when needed, then click the formula cell again to test the updated link.

Work with Spreadsheet Hyperlinks in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Excel formats, making it easy to move existing spreadsheets. Use WPS Spreadsheets to work with worksheet hyperlinks; it does not fix the Excel object behavior described above.

Frequently Asked Questions
Why does the hyperlink work in the cell but not in the object?
The object can display a linked cell's value, but it does not generally inherit the clickable behavior of the cell's HYPERLINK formula. Click the formula cell to open the destination.
Can I assign a hyperlink to an Excel object manually?
Yes. Select the object and use Insert > Link or press Ctrl+K to assign a hyperlink. That link must be updated manually if the destination changes.
How can I change the link destination without editing the formula?
Put the URL in a separate cell, such as A2, and use a formula such as =HYPERLINK(A2,"Open link"). Change A2 to update the destination.
Can VBA make an object's hyperlink follow a cell?
Yes. VBA can update the object's assigned hyperlink when the destination value changes. The exact event and code depend on whether the value is edited directly or changes through recalculation.




