Well, I have a bigger problem then. It is not possible to have the linked
workbook open. The link needs to access the file while it is closed.

Is there another function that will get me the "link" results without having
to open the other workbook first?

Ken


"Max" wrote:

"Ken" wrote:
... In Book 1 I have this.
A1= =[C:\Documents and Settings\kf\Desktop\2.xls]Sheet1!
A2= =INDIRECT(A1&"A1")

Try these amendments:

In A1: C:\Documents and Settings\kf\Desktop\[2.xls]Sheet1'!
In A2: =INDIRECT("'"&A1&"A1")

And, importantly, we need the linked book: 2.xls to be open as well.
INDIRECT requires the linked book to be open for it to work, otherwise even
with the correct syntax, etc, it'll show as #REF!
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--