View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Vlookup Error Message - Excel 2003

When you say spreadsheets, do you mean files or workbooks? If so, Excel does
not like large external databases.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kim" wrote in message
...
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?