Hyperlinks don't change when inserting col/rows

DaveAtlanta

Board Regular
Joined
Nov 9, 2005
Messages
100
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Swaroon

Active Member
Joined
Nov 18, 2005
Messages
278
Could you set up each cell as a name range instaed of cell reference ?
 

DaveAtlanta

Board Regular
Joined
Nov 9, 2005
Messages
100
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

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Dave

How did you actually create these hyperlinks?

Did you just goto Insert>Hyperlinks...?
 

DaveAtlanta

Board Regular
Joined
Nov 9, 2005
Messages
100

ADVERTISEMENT

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

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Do you mean right click then Hyperlink...?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,087
Members
412,566
Latest member
TexasTony
Top