Forum Discussion
HYPERLINK function returns "Cannot open specified file"
=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
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.
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
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")
- Thank you for offering to help, but I got the problem resolved.
- Nice one guys! Willy, haven't seen you in a while. Good to see you around.
Have a great weekend all!
Cheers
Damien
