Thanks Dave, I will give that a try.


"Dave Peterson" wrote:

Or...

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that may help.

Maybe it'll be faster than the pull function that you used.

GSM wrote:

I have implemented the "pull" function to indirectly reference data in
external spreadsheets that are closed. This is very slow (almost .5 seconds
per cell). I have about 500 cells to update so it takes awhile whenever I do
a manual update.

Is there a faster solution out there yet? Thanks in advance.

--

Dave Peterson