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")
actually, i can use your formulas on a new excel workbook, just not in my existing workbook. as you will see in the attached jpg each tab/sheet is a single name
I was suggesting that sometimes, accidentally, a space could be after the sheet name which isn't visible to the eye but might be sitting there as space is a character.
Anyway, the only other option I can think of to fix the issue is to recreate your sheets in a new workbook and see if that fixes the problem which is not ideal but may be worthwhile in the long run.
Cheers
Damien