Excel Linking

[LaNeise]

I'm have linking 2 worksheets together but lets say the first on say
1
2
3
and the the second says the same, but when I insert another row such as
123
1
2
3
the linked worksheet does keep 1 as the value. This is just an example
because my worksheet is alot bigger than this. Can anyone help please?

 

[NUMBnut]

You have to edit the hyperlink in order to update it with the new information.

 

[LaNeise]

How is that done

You have to edit the hyperlink in order to update it with the new information.

 

[LaNeise]

That didnt work

How is that done

 

[NUMBnut]

Right click on hyperlink and go to edit hyperlink...
At the top there should be a box called "Text to Display" type in whatever
you want the hyperlink to show. Then check to make sure it has the correct
source location.

 

[LaNeise]

I change that worksheet alot, will I have to do this for every hyperlink that
I have?

 

[NUMBnut]

Unfortunately, yes. Hyperlinks will not automaticly update themselves. They
will only update the values.

 

[LaNeise]

Thanks

Unfortunately, yes. Hyperlinks will not automaticly update themselves. They
will only update the values.