Maintaining a hyperlink to moved data within the work book
 

Excel 2000. Cell A1 has a hyperlink to Cell A2. If I cut and paste A2 to,
say, A3, the hyperlink does not change its destination. A1 is still linked
to A2. How can I get the hyperlink to change its destination to the new
location of the cut and pasted data?

It must be possible, surely.....

Regards
Kev Nurse

If you give A2 a nice name (Insert|Name) and use that name in the hyperlink,
does that help?

Kev Nurse wrote:

Excel 2000. Cell A1 has a hyperlink to Cell A2. If I cut and paste A2 to,
say, A3, the hyperlink does not change its destination. A1 is still linked
to A2. How can I get the hyperlink to change its destination to the new
location of the cut and pasted data?

It must be possible, surely.....

Regards
Kev Nurse

--

Dave Peterson