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

Jan Grobbelaar

Copper Contributor

Nov 15, 2018

Thank you for offering to help, but I got the problem resolved.

Damien_Rosario

Silver Contributor

Nov 15, 2018

Nice one guys! Willy, haven't seen you in a while. Good to see you around.

Have a great weekend all!

Cheers
Damien