Forum Discussion

Jan Grobbelaar's avatar
Jan Grobbelaar
Copper Contributor
Nov 13, 2018
Solved

HYPERLINK function returns "Cannot open specified file"

I am trying to use the HYPERLINK function but to no avail. I have exhausted all the standard help available on this, but I cannot figure out what is wrong, Here is an example of the syntax I am tryin...
excel
Formulas and Functions
office 365
  • Willy Lau's avatar
    Willy Lau
    Nov 14, 2018
    =HYPERLINK("#$A$3","Somewhere in the same worksheet")

    or

    =HYPERLINK("#'ANOTHER SHEET'!$A$3","Somewhere in another worksheet")

    if you want a dynamic link in cell A3, put

    #A5

    then, the hyperlink function

    =HYPERLINK($A$3, "Somewhere pointed by Cell A3")
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Jan 14, 2019

Hi Jamie Sutherland

 

 

Give this formula a try for linking within the same workbook:

=HYPERLINK("#TEMPLATE!C1","Go to TEMPLATE > C1")

 

In terms of using other cells to piece together a hyperlink (this example uses , copy and try:

=HYPERLINK("#"&"'" & B3 & "'!" & A1, "Go To Sheet")

 

See how you go?

 

Cheers

Damien

SmallThings1991's avatar
SmallThings1991
Copper Contributor
Apr 12, 2019

Hi, This did solve my problem with the error messages I was getting but its not dynamic and moving when rows are added in. Please, can you help?

 

=HYPERLINK("#Sheet1!A20", "Fuel Systems")

 

Damien_Rosario 

  • Willy Lau's avatar
    Willy Lau
    Steel Contributor
    Jun 11, 2019
    You may try
    =HYPERLINK("#Sheet1!" & ADDRESS(ROW(A20),COLUMN(A20)), "Fuel Systems")