Linking formulas from seperate workbook

[Guest]

I am using Microsoft Office Excel 2003. Im not sure whether this is possible
at all, but is there a way to make a formula where you extract data from
seperate workbooks? I know you can do this using seperate worksheets, but
unsure in regards to workbooks.

 

[David Biddulph]

Yes, but you can get into difficulties if the other workbooks aren't open
when you try to update values.