Problem with excel hyperlink inside excel
Problem with excel hyperlink inside excel
(OP)
When I use the formula:
=HYPERLINK('SheetName!A8,"●")
The hyperlink works.
When I copy the formula to other cells, like this:
=HYPERLINK('SheetName!A200,"●")
and follow the hyperlink, it puts me back into cell A8, not cell A200.
Any ideas why?
=HYPERLINK('SheetName!A8,"●")
The hyperlink works.
When I copy the formula to other cells, like this:
=HYPERLINK('SheetName!A200,"●")
and follow the hyperlink, it puts me back into cell A8, not cell A200.
Any ideas why?





RE: Problem with excel hyperlink inside excel
My experience with HYPERLINK is very limited. The one time I tried to use it I had difficulties coming up with a format for jumping to cells on the same worksheet without having to embed the name of the worksheet in the function. What I eventually got to work satisfactorily was
=HYPERLINK("#"&ADDRESS(ROW(A29),COLUMN(A29),4),"●")
This is probably not relevant to your problem, but I include it here just in case.
RE: Problem with excel hyperlink inside excel
It is so weird. The formula doesn't act the same, depending on the mood of microsoft.
Sometimes it jumps me to the wrong cell, sometimes it tells me it can't open the file.
I inserted the hyperlinks manually. In the end it took less time than hunting for a solution online.
RE: Problem with excel hyperlink inside excel