Forum Discussion
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...
=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")
am getting this error msg when i am trying to do hyper link with in a work book
can you please help me out with your expertise
Hi Josephbennet
Hope you are well.
Give this one a go:
=HYPERLINK("#AT-3FE8D3X-048!D31")
Good luck
Damien