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")
Hey Damien,
Not sure what the issue is. Try simulating in a new Workbook to see if you still have the same issue?
Check your tab doesn't have any spaces in the name as well.
Otherwise, might need to log a support ticket with Microsoft?
Hope you figure it out! Let me know if any of the above works?
Cheers
Damien
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
