[Solved]Indirect.ext error

**dag62** · 08-06-2012, 01:45 AM

I have a list of 100 workbooks with different names in column A. I used =INDIRECT.EXT to access these files however it will only access them when the files are open. There are too many files to have open simultaneously.

This is the complete formula I am using =INDIRECT.EXT("'["&A9&"]"&$C$5&"'!"&$C$1).

A9 is the filename trying to access,
C5 is the worksheet name same for all files
C1 the cell address same for all files.

This worked when the files are open but when I close the files the formula results changed to #REF!

How do I keep the actual results? I thought INDIRECT.EXT was able to access closed files.

Any help is greatly appreciated.

**Pete_UK** · 08-06-2012, 03:44 AM

You need to include the full path to those files. If they are all in the same folder and you have the path to that folder in A1, then you can do this:

=INDIRECT.EXT("'"&$A$1&"["&A9&"]"&$C$5&"'!"&$C$1)

Hope this helps.

Pete