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.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"chikop" wrote:

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.