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.