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" 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?

[LaNeise]

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?

[LaNeise]

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?

[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" 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?

[LaNeise]

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?

[NUMBnut]

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?

[LaNeise]

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?