You can download an add-in called Morefunc it has a function called
INDIRECT.EXT which will work if the source book is closed

Refer
http://xcell05.free.fr/morefunc/english/index.htm

If this post helps click Yes
---------------
Jacob Skaria


"Kash" wrote:

But for INDIRECT, other file should be open right? But, how to go if file is
closed?