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.

Open, Copy, Paste, Close. Not sexy but works.

--
Jim
"GSM" wrote in message
...
|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.
|

Or maybe build the formula in code and populate the cells with that formula that
points at the specific workbook (not using indirect at all).

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

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

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