M
MikeNZ
I am working on a spreadsheet which uses gets information from an external
excel file. Initially I was using VLOOKUP, which I have since changed to
INDEX(MATCH)). Either way I get the same problem, which is the error message
in the subject. The External excel file is approx 17k rows long and 4 colums
the data in the external file is sourced from an ODBC connection which is set
to update only when the file is opened. There are approx. 30 lookups to do
against this external file. I have another external file which is static and
only 100 rows and 3 colums and the INDEX(MATCH()) is working fine for this
file. Does anyone have any ideas ?
excel file. Initially I was using VLOOKUP, which I have since changed to
INDEX(MATCH)). Either way I get the same problem, which is the error message
in the subject. The External excel file is approx 17k rows long and 4 colums
the data in the external file is sourced from an ODBC connection which is set
to update only when the file is opened. There are approx. 30 lookups to do
against this external file. I have another external file which is static and
only 100 rows and 3 colums and the INDEX(MATCH()) is working fine for this
file. Does anyone have any ideas ?