Previous Topic Next Topic

INDIRECT formula alternative?

Closed
SPARC Posts 1 Registration date Thursday June 2, 2011 Status Member Last seen June 2, 2011 - Jun 2, 2011 at 10:26 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 2, 2011 at 06:01 PM
Hello,

I would like to know if anyone can offer an alternative to using the INDIRECT function in a formula in order to pull from another worksheet in an Excel Workbook?

I have a file that has a very large number of worksheets, and at least one third of the worksheets need to pull information in multiple cells from other worksheets in the file. While INDIRECT certainly works, it really bogs down the file as it is volatile and must relcalculate far too often.
Related:

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jun 2, 2011 at 06:01 PM
Have you tried the INDIRECT.EXT function in addon MOREFUNC. I dont know how its performance is vs INDIRECT. But you get advantage that workbook need no to opened for indirect to work
0