Greetings! I am using VISTA and Excel 2007. In sheet B I have hyperlinks to
certain cells in sheet A. That is, when I insert a hyperlink in sheet B, in
"Insert Hyperlink," "Place in This Document," I type in the cell reference,
say A2332.

I have about one 80 hyperlinks in sheet B that if clicked, take me to
various places in sheet A. A problem arises when I insert (or delete) a row
(or rows) in sheet A, which puts all the hyperlinks in sheet B off by one or
more rows.

Is there anyway to update the hyperlinks in sheet B? I can do it manually,
but it will take forever, especially if I insert or delete rows in sheet A
occasionally.

I do not know how to program, but it would be nice to have some way to
update these hyperlinks. Do any of the experts have any suggestions? I'm
stumped.

Define names for the cells you want and then link to the names.

Suppose you want to link to A2 in Sheet1

Go to A2 in Sheet1
In the address box where you see A2 type a friendly name (say CellA2), press
enter
Go to Insert Hyperlink and you will see Cell2 under Defined Names... link to
CellA2. When you insert or delete the link will keep pointing to CellA2 (the
original A2)

"Rebecca" wrote:

Greetings! I am using VISTA and Excel 2007. In sheet B I have hyperlinks to
certain cells in sheet A. That is, when I insert a hyperlink in sheet B, in
"Insert Hyperlink," "Place in This Document," I type in the cell reference,
say A2332.

I have about one 80 hyperlinks in sheet B that if clicked, take me to
various places in sheet A. A problem arises when I insert (or delete) a row
(or rows) in sheet A, which puts all the hyperlinks in sheet B off by one or
more rows.

Is there anyway to update the hyperlinks in sheet B? I can do it manually,
but it will take forever, especially if I insert or delete rows in sheet A
occasionally.

I do not know how to program, but it would be nice to have some way to
update these hyperlinks. Do any of the experts have any suggestions? I'm
stumped.