I am trying to use indirect reference to a large number of closed Excel workbooks. I am working in Excel 2007. In Excel 2003, MoreFunc allows use of the INDIRECT.EXT function, which pretty quickly allows reference to a large number of closed workbooks.
For Excel 2007, there is the alternative of code for the "PULL" function, that can substitute for INDIRECT.EXT in the reference formulas; however, PULL is very, very slow, making it impractical for references many hundreds of workbooks.
Are there any alternative means for using an INDIRECT-like function to reference closed workbooks? The workbook in which I'm working has all of the workbook location in columnA , all the file names in column B, and the relevant worksheet name in column C. In cell D1, I list the cell reference to be refernce, and in cells D2.....Di, I have the formulas for indirect reference - but I cannot find a practical solution!
I attached an example of what I'm working with, but need an alternative to the INDIRECT.EXT formulas.
You assistance is greatly appreciated!