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")
=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")
Willy Lau I tried the formulas but can't seem to get it to work in Office 365.
What I am trying to do is create a hyperlink to a changing cell in the next screen.
=INDIRECT(CONCATENATE("'Lines Parts'!",ADDRESS(1,SUM(COUNTA('Lines Parts'!$A$1:$ZZ$1)))
Currently that formula returns the value of the cell that I am trying to hyperlink to. Each month, it will need to change to the new column of data, as we register it month over month.
When I tried to hyperlink it, it says "Cannot open the specified file".
- Thank you very much!
