INDIRECT function

E

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
 
D

Dave Peterson

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

Ernie said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top