Linking information between workbooks

[Jenny Potter]

I have 3 Excel 2003 workbooks.
Workbook 1 - holds a number of worksheets. I have a worksheet called 'Home'
where client details are entered into specific cells (eg: Name, Client Code,
Year End date) and then it flows into the worksheets of each worksheet
contained within this workbook. This is all fine as I just have to use the
=Home!$F$4 function.
Workbook 2 - Client details needs to be linked from Workbook 1 ('Home'
worksheet) and automatically updated when Workbook 2 is opened. How do I do
this?
Workbook 3 - Client details need to be linked from Workbook 1 ('Home')
worksheet) and automatically updated when Workbook 3 is opened. How do I do
this?

[Paul Sheppard]

I have 3 Excel 2003 workbooks.
Workbook 1 - holds a number of worksheets. I have a worksheet called 'Home'
where client details are entered into specific cells (eg: Name, Client Code,
Year End date) and then it flows into the worksheets of each worksheet
contained within this workbook. This is all fine as I just have to use the
=Home!$F$4 function.
Workbook 2 - Client details needs to be linked from Workbook 1 ('Home'
worksheet) and automatically updated when Workbook 2 is opened. How do I do
this?
Workbook 3 - Client details need to be linked from Workbook 1 ('Home')
worksheet) and automatically updated when Workbook 3 is opened. How do I do
this?

Hi Jenny

Open workbook 1 and 2, in workbook 2 go to a cell you want to link to workbook 1, type = in the cell and then go to workbook 1 and click on the cell you want it to link to

Do the same for all cells you want a link, for both workbooks 2 & 3

[yh73090]

Hi Paul,

Sorry I saw this post and it was pretty much what I was looking for with the exception of:

Will the link work if the receiving workbook is closed?

Thanks,

Yolanda