| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Error Message - Excel 2003
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message adaytum.xla when closing workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Message | Excel Discussion (Misc queries) | |||
| error message during vlookup | Excel Discussion (Misc queries) | |||
| Document Not Saved Error Message - Excel 2003 | Excel Discussion (Misc queries) | |||
| VLOOKUP error message | Excel Discussion (Misc queries) | |||
Threaded Mode
