what specifically prevents INDIRECT from accessing closed worksheets

Only MS knows for sure!

what would it take to enable this important functionality?

An act of God! People have been asking for this for years.


--
Biff
Microsoft Excel MVP


"z.entropic" wrote in message
...
What prompted my question is the slowness and finicky nature of
INDIRECT.EXT
on one hand and the inability of Harlan Grove's PULL function to deal with
active cell addresses for copying formulas by dragging on another. For
example, =PULL("'C:\[test.xls]Results'!A3") will work, but will give the
same
A3 value for all the dragged and copied cells, but
=PULL("'C:\[test.xls]Results'!"&A3) is NOT allowed.

So, what specifically prevents INDIRECT from accessing closed worksheets,
and what would it take to enable this important functionality?

z.entropic