You could try Harlan Grove's PULL function. You can get it
ftp://members.aol.com/hrlngrv/ (look for pull.zip)

You would use it like so

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!"&"B5")

As for alternatives, try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from


http://xcell05.free.fr/english/


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Shuang" wrote in message
...
A workseet contains a lot of INDIRECT() functions, each INDIRECT() function
contains a link to another EXCEL file. Seems other EXCEL files should be
open, otherwise, reference error occurs. Because there are many other
EXCEL
files, it is uncomfortable to open many EXCEL windows.

Are there any ways to use this kind of INDIRECT functions without opening
other
files?

Thanks,