INDIRECT function

[Ernie Fenwick]

I have a series of files in the same directory and wish to interrogate them
from a summary file. I have been advised the the INDIRECT function will do
the trick and it works fine as long as the source file is open. I have seen
from other postings tghat INDIRECT.EXT works with closed files. I have
downloaded morefunc and using INDIRECT.EXT I still get the same result, ie
the formula gives the correct result when the source file is open but gives
a #REF! response when the file is closed. the formula I am using is
=INDIRECT.EXT("[Losses"&B5&".xls]Sheet1!B4") where Losses11.xls is the
source file and B5 contains 11. If I remove the ".EXT" from the formula it
works in exactly the same way. I have removed all spaces from the filenames.

Regards

Ernie

 

[Dave Peterson]

If the file is closed, you're going to have to add the drive and path to the
formula.

I have a series of files in the same directory and wish to interrogate them
from a summary file. I have been advised the the INDIRECT function will do
the trick and it works fine as long as the source file is open. I have seen
from other postings tghat INDIRECT.EXT works with closed files. I have
downloaded morefunc and using INDIRECT.EXT I still get the same result, ie
the formula gives the correct result when the source file is open but gives
a #REF! response when the file is closed. the formula I am using is
=INDIRECT.EXT("[Losses"&B5&".xls]Sheet1!B4") where Losses11.xls is the
source file and B5 contains 11. If I remove the ".EXT" from the formula it
works in exactly the same way. I have removed all spaces from the filenames.

Regards

Ernie