Indirect referencing of external spreadsheets

G

GSM

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.
 
J

Jim Rech

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

--
Jim
|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.
|
 
D

Dave Peterson

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).
 
Top