Links between Sheets

  • Thread starter Thread starter Warren Easton
  • Start date Start date
W

Warren Easton

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
 
Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew
 
like this
=Sheet2!B1

stew said:
Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew
Click to expand...
 
Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.
 
Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew
 
Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

Warren Easton said:
Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.
Click to expand...
Click to expand...
 
Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

Warren Easton said:
Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

Warren Easton said:
Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down
somwhere.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

Warren Easton said:
Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

:

Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
Can you give me a copy of the link

and are you saving after you enter the path

Best

Stewart
If this helps please click the Yes button.


Warren Easton said:
Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down
somwhere.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

Warren Easton said:
Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

:

Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5

Yes I am saving the the workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



stew said:
Can you give me a copy of the link

and are you saving after you enter the path

Best

Stewart
If this helps please click the Yes button.


Warren Easton said:
Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down
somwhere.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

:

Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

:

Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
If you remove :$D$5 from the routing the all works fine for me

With the reference you are using to Twinwire Estimating Sheet.xls you
asking for a 2 cells to be displayed in on cell. If that is what you want
then
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5&" "&'[Twinwire Estimating
Sheet.xls]Start Sheet'!$D$5
Does it

As for the Opening and Shutting of the worksbooks my examples work fine

Let Me Know

Stew

Warren Easton said:
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5

Yes I am saving the the workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



stew said:
Can you give me a copy of the link

and are you saving after you enter the path

Best

Stewart
If this helps please click the Yes button.


Warren Easton said:
Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down
somwhere.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

:

Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

:

Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
Hi Stew,

This could be the problem the cells are merged, but I've taken $D$5 away and
it seems to be working. Thank you for the time you spent on this.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
If you remove :$D$5 from the routing the all works fine for me

With the reference you are using to Twinwire Estimating Sheet.xls you
asking for a 2 cells to be displayed in on cell. If that is what you want
then
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5&" "&'[Twinwire Estimating
Sheet.xls]Start Sheet'!$D$5
Does it

As for the Opening and Shutting of the worksbooks my examples work fine

Let Me Know

Stew

Warren Easton said:
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5

Yes I am saving the the workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



stew said:
Can you give me a copy of the link

and are you saving after you enter the path

Best

Stewart
If this helps please click the Yes button.


:

Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down
somwhere.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

:

Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

:

Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
I have been helped so many times on this site , its good to give back

Merry Christmas from The Island Of Cumbrae

Stew

Warren Easton said:
Hi Stew,

This could be the problem the cells are merged, but I've taken $D$5 away and
it seems to be working. Thank you for the time you spent on this.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


stew said:
If you remove :$D$5 from the routing the all works fine for me

With the reference you are using to Twinwire Estimating Sheet.xls you
asking for a 2 cells to be displayed in on cell. If that is what you want
then
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5&" "&'[Twinwire Estimating
Sheet.xls]Start Sheet'!$D$5
Does it

As for the Opening and Shutting of the worksbooks my examples work fine

Let Me Know

Stew

Warren Easton said:
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5

Yes I am saving the the workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

Can you give me a copy of the link

and are you saving after you enter the path

Best

Stewart
If this helps please click the Yes button.


:

Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down
somwhere.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
In one work book will pick out the value in C111 in another work book.

If the value in C111 changes then that will be reflected in the original
wookbook. Is this what you are after?

Best

Stew

:

Thanks Stew,

My path looks similar, and works the first time I input it, but if I close
the workbooks then reopen them they don't change in the destination cell.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


:

Dear Warren

This is a copy of one link that I use from one work book to another. You
will see that you have to give the complete path to cell c111
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Hope this helps

You can also do it with an Indirect Function whoever the Second work book
has to be open to use that

Best

Stew

:

Sorry Stew,

I should have explained this better, it's in another workbook.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



:

like this
=Sheet2!B1

:

Dear Warren

= then click on tab to sheet that you want to connect to and click on the
cell on that sheet then tab out of formula should do it

Stew

:

Dear All,

I have an excel spreadsheet that has links to two other sheets, I've just
typed in = then went to the sheet and clicked on the cell I want to link to.
Everytime I open these sheets the links between then turn to source unknown
and they don't update on the first sheet. Can anyone advise what I'm doing
wrong?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top