Excel Linking
Thanks
"NUMBnut" wrote:
Unfortunately, yes. Hyperlinks will not automaticly update themselves. They
will only update the values.
"LaNeise" wrote:
I change that worksheet alot, will I have to do this for every hyperlink that
I have?
"NUMBnut" wrote:
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" wrote:
That didnt work
"LaNeise" wrote:
How is that done
"NUMBnut" wrote:
You have to edit the hyperlink in order to update it with the new information.
"LaNeise" wrote:
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?
|