Laurent Longre wrote...
....
I have recently changed the code of this function, it could work
better in these
configurations (I can't be sure, because I have only XP). Otherwise
I'm working
on another function named INDIRECT2, but it is only a pre-beta
version. It
parses directly the binary Excel file format. If you want to take a
look:
http://xcell05.free.fr/forums/viewtopic.php?id=27.
....

Parsing binary files is suboptimal. Systems on which INDIRECT.EXT and
pull work can extract values from the supported 123 .WK? file formats
in addition to all .XLS file formats. Which versions of the .XLS file
format would you support? How about XL4 .XLW file format? The 123 .WK?
file formats?

INDIRECT2 reading closed files directly may be faster, but if speed is
the main requirement, using formulas like

="='"&Pathname&"\["&Filename&"]"&Sheetname&"'!"&RangeAddress

to generate string representations of external reference links, copying
them and pasting special as values, then using Edit Replace to
replace = with = in the pasted range would convert text constants to
formulas, and those explicit external reference links would calculate
faster than any add-in function.

Just my opinion, but flexibility is the paramount need in this type of
function. Your INDIRECT2 would seem to reduce flexibility compared to
INDIRECT.EXT.