Forum Discussion

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

Nov 14, 2018

=HYPERLINK("#$A$3","Somewhere in the same worksheet")

=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")

Jamie Sutherland

Copper Contributor

Jan 14, 2019

Hi Damien,

my hyperlinks dont go to the corresponding sheet. all get errors.

i have tried different hyperlink formulas. please see my screenshots.

for example, in my first screenshot, when i select the first (blue) link at the top of the screen, i get "an unexpected error has occurred.

i get the same response when i select the (black) link under it.

the thrid image show my spreadsheet in its whole.

can you see what is causing the errors?

thanks for your help.

Damien_Rosario

Silver Contributor

Jan 15, 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