A linked cell can be created to an existing workbook with a formula like so:
What amazes me is how the formula text toggles automatically when that
external file is either open or not...
When it is open
='[Bill.xls]Sheet1'!$A$1
When you had it open but it has since been closed
='C:\[Bill.xls]Sheet1'!$A$1

Don't worry, as long as the link was validly created, if you close the
workbook with the formula first, then the external workbook, then open the
workbook with the formula again, the full path will appear.


"Gary Keramidas" wrote in message
...
is there a way to copy cell values from an unopened workbook and add that
value to an existing value in an opened workbook?

--


Gary