Function Problems

Create a Dynamic Hyperlink for an Excel Object Without VBA

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 869 views

Question details

The user wants an Excel object to open a dynamic hyperlink from a linked cell without using VBA.

Create a Dynamic Hyperlink for an Excel Object Without 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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the destination

In the worksheet, enter the destination URL in a cell such as A2. For example, enter https://example.com.

2
Create the formula

Select the cell you want users to click and enter =HYPERLINK(A2,"Open link"). Press Enter to display the link text.

3
Test and format the cell

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.

4
Update the destination

Change the URL in A2 when needed, then click the formula cell again to test the updated link.

Use the Dynamic Hyperlink Directly in a Worksheet Cell
If the object itself must be clickable: A manually assigned object hyperlink does not automatically follow the linked cell's formula. VBA can be used to update the object's hyperlink when the destination changes.
Free Microsoft Office alternative

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.

Work with hyperlinks directly in spreadsheet cellsOpen and save Microsoft Excel formats, including XLSXUse a familiar spreadsheet interface for an easier transitionGet a free, lightweight Office alternative
microsoft office alternative - wps office

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.