INDIRECT references to closed external workbooks in 64-bit Excel 2010

**Hambone70** · 03-20-2011, 01:58 PM

Is this possible?

All I can find are vague, outdated references to methods that do NOT seem to work in 64-bit Excel 2010.

**shg** · 03-20-2011, 02:41 PM

INDIRECT has never worked with closed workbooks.

MoreFunc's INDIRECT.EXT does.

**Hambone70** · 03-20-2011, 03:11 PM

AFAIK, MoreFunc is incompatible with Excel 2010.

The installation doesn't seem to result in the additional functions.

**shg** · 03-20-2011, 03:22 PM

Appears so; see http://www.mrexcel.com/forum/showthread.php?t=473056

I think API declarations have to include PTRSAFE for 64 bit, which requires changes to the source code.

Re: INDIRECT references to closed external workbooks in 64-bit Excel 2010