Hello,
Not sure my approach of fetching data from an external file is an efficient way. In the source file, I defined the named ranges. Then in the workbook, I used the INDEX() function and those named ranges to get data from the external source file. For example, =INDEX(SourceFile!Range1, 1) is to get the first cell in the named range "Range1".
Due to the size of the source file and workbook (both have 5000 rows and 100 columns, over 50MB), I found this approach may have efficiency problem, as I had to wait over 15 minutes to get the file updated and crashed in a few occasions. Is this because the file size is too large? Or the INDEX() function is not efficient?
I appreciate your great help for this problem.
Bookmarks