The hyperlink reference doesn't changes when I insert Rows and co.

[chikop]

I can jump to the cell be defining a hyperlink option from the right click
menu but this reference remains constant and doesn't follows the reffered
cell when I insert a Row or a column.
The Hyperlink() funtion also throws the Error "Cannot Open Specified file".
PS:
I'm trying to hyperlink the cell within the sameworksheet of same workbook.
I'm using Office 2002 sp3 on Windows XP SP3.

 

[Gary Brown]

The =Hyperlink(Link_Location,Friendly_Name) worksheet function will change
the 'Link_Location' if rows are inserted while the right-click Hyperlink
option hard-codes the original Link_Location. For example, if Cell B1
contains the formula =Hyperlink(G5,"My Link"), inserting a row @ row 3 will
change the formula to =Hyperlink(G6,"My Link"). The right-click Hyperlink
option that references Cell G5 will continue to reference G5 after a row
insert.

 

[d.louchbaum]

I ran into the same problem too and came across another solution to
the problem. Highlight the cell (or cell range) that you want to link
to. In the upper left corner where there is a white 'Name Box' where
you can give the cell a name. In this case we will name the cell
"LinkA". Now right click the cell where you want the hyperlink to
appear and go to "Hyperlink" or "Edit Hyperlink". You want to be on
the tab "Link to Place in This Document". Now slide the scroll bar to
the bottom where you see "Defined Names". Here you will see "LinkA"
appear... select it and hit OK. When the cell gets pushed around by
inserting/deleting rows and whatnot the "LinkA" name will also shift,
along with your hyperlink destination.