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