Using Hyperlink Function

[Ailish]

Hi

I am using the following formula in A1 in Sheet1 to link to Sheet3 C5. The
formula seems correct and is in blue and underlined. But when I point the
mouse at the cell although I get the hand to indicate a link when I click
nothing happens. It is a brand new workbook so the sheets it is trying to
find etc. are there.

=HYPERLINK(Sheet3!C5,"Click Here")

Any Ideas?

Thanks
Ailish

 

[Pete_UK]

Try it this way:

=HYPERLINK("#Sheet3!C5","Click Here")

The # is needed to indicate "this workbook" - it's an HTML thing - and
the quotes are needed as it can be a calculated address.

Hope this helps.

Pete

 

[Jacob Skaria]

It should be
=HYPERLINK("#Sheet3!C5","Click Here")

If this post helps click Yes

 

[Dave Peterson]

I'd use something like this:

=HYPERLINK("#"&CELL("address",sheet3!C5),"Click Here")

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

The thing that's very nice about David's syntax is that if you insert or delete
rows/columns in Sheet3, then the formula will point to the new location.

This syntax:
=HYPERLINK("#Sheet3!C5","Click Here")

Will always point at C5 of Sheet3--no matter if you insert/delete rows or
columns.

So you'll want to choose the one that fits your requirements.

 

[Ailish O'Connor]

Thanks a million for the reply worked a treat.

Ailish



Dave Peterson wrote:

Re: Using Hyperlink Function
25-Aug-09

I'd use something like this

=HYPERLINK("#"&CELL("address",sheet3!C5),"Click Here"

David McRitchie posted this and it might help you

=HYPERLINK("#"&CELL("address",C5),C5
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5

The thing that's very nice about David's syntax is that if you insert or delet
rows/columns in Sheet3, then the formula will point to the new location

This syntax
=HYPERLINK("#Sheet3!C5","Click Here"

Will always point at C5 of Sheet3--no matter if you insert/delete rows o
columns

So you'll want to choose the one that fits your requirements

Ailish wrote

--

Dave Peterson

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx

 

[Ailish O'Connor]

thanks for the reply it worked perfectly.

Ailish



JacobSkari wrote:

RE: Using Hyperlink Function
25-Aug-09

It should b
=HYPERLINK("#Sheet3!C5","Click Here"

If this post helps click Ye
--------------
Jacob Skari

:

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx