Excel cannot complete this task with available resources (Excel 20

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
Also when I have both the main spreadsheet and the external spreadsheet open
everything works fine.
 
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

Excel out of resources - help ! 4
"Excel cannot complete this task with available resources" 2
excel external data range "failed to refresh" 0
Excel cannot find or read file 5
excel external data range failed to refresh - second try 1
Excel cannot complete this task with available resources 6
Available resources 1
making an excel table visible for external data on pivot table 1

Back
Top