Indirect referencing of external spreadsheets

  • Thread starter Thread starter GSM
  • Start date Start date
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.
 
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.
|
 
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).
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect referencing closed spreadsheets 1
External reference for Offset formula 2
Variations on referencing a cell in another workbook - continued 4
Referencing another worksheet 10
Links to External Spreadsheet (using a variable in the link) 2
INDIRECT function do not work when other file is closed 4
variable substitution in a formula linking to external workbook 2
INDIRECT doesn't retain data from external worksheets 2

Back
Top