if you have 600K rows of data, your IT is correct to suggest using a database
application. However, for 20K rows ++ of data, Excel can handle that.

Try closing other applications that are running at the same time
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Kim" wrote:

I have two vlookup functions in one spreadsheet linking data from two other
spreadsheets. I have 23K rows and I received an error of "Excel cannot
complete this task with available resources. Choose less data or close other
applications." My IT department is saying that I should query data in a table
(access) rather than storing data of 20K + rows using the Vlookup in excel.
Shouldn't excel be able to handle 600K rows of data using the Vlookup
function?