Thread
:
Vlookup Error Message - Excel 2003
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett