Hyperlinks don't change when inserting col/rows

[DaveAtlanta]

I must be doing something wrong with my settings or method.

I have linked several hundred cells with hyperlinks to another worksheet. When I need to insert a new column or row to my list, I have to manual go and update every hyperlink to the new col/row line. I thought that they would perform like formulas and auto-detect moving.

is there a way to have my hyperlinks remember where they are linked to and adjust as my worksheet adjust?

Dave

 

[Swaroon]

Could you set up each cell as a name range instaed of cell reference ?

 

[DaveAtlanta]

I would need to name more then 2000 cells, which could be a benefit in the long run, but time consuming now.

I thought there was a method or setting that had to be done.
Dave

 

[Norie]

Dave

How did you actually create these hyperlinks?

Did you just goto Insert>Hyperlinks...?

 

[DaveAtlanta]

Created by Right-Click on first cell, linked to related cell on other sheet.

Each cell relates to other data on sheet2. I thought it would make it easier for others to view this information by using they hyperlink directly to the related spot. Everytime I get a new set of information I insert the column where it needs to be, but then I have to re-update all my hyperlinks.

 

[Norie]

Do you mean right click then Hyperlink...?

 

[DaveAtlanta]

Yes, sorry