Problem with excel hyperlink inside excel

[FiltrationEngineer]

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?

 

[Denial]

I cannot reproduce your problem with Excel-2003 (even allowing for an errant single quote or two). What version are you using?

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.

 

[FiltrationEngineer]

I'm using Excel 2007.

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.

 

[Dad1125]

When you move the formula to another cell, Excel maintains the exact relationship (cell to cell) that was created in the first cell. A way to avoid the cell location change is to place the cursor in the formula cell address(A200) and press F4 which makes the cell location an absolute address (Excell places the "$" in the address to make it an absolute value i.e. "$A$200") Hitting F4 again will make the row absolute and hitting F4 again will make the column absolute