Links between Sheets
 

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.

Links between Sheets
 

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

"Warren Easton" wrote:

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.

Links between Sheets
 

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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

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



"stew" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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

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



"stew" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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" wrote:

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

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



"stew" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.

Links between Sheets
 

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" wrote:

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" wrote:

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" wrote:

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

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



"stew" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

Sorry Stew,

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



"stew" wrote:

like this
=Sheet2!B1

"stew" wrote:

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

"Warren Easton" wrote:

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.