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?

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?

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?

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?

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?

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?