| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
what is the maximum number of vlookups in a given workbook that E.
I have a workbook that has large amounts of vlookups (about 15,000). My
Excel workbook keeps giving me an error message that there are not enough Excel resources and it cannot save external values. Is there a limtation on the number of lookups that can be supported in Excel? Thanks in advance.... |
|
#2
|
|||
|
|||
|
what is the maximum number of vlookups in a given workbook that E.
There is no limit on lookups per se, but there are limits on
Excel as a whole based on the available memory on the machine. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bartman" wrote in message ... I have a workbook that has large amounts of vlookups (about 15,000). My Excel workbook keeps giving me an error message that there are not enough Excel resources and it cannot save external values. Is there a limtation on the number of lookups that can be supported in Excel? Thanks in advance.... |
|
#3
|
|||
|
|||
|
what is the maximum number of vlookups in a given workbook that E.
I should have added that you might want to have a look at Charles
William's http://www.decisionmodels.com/memlimits.htm for a discussion of memory limits in Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... There is no limit on lookups per se, but there are limits on Excel as a whole based on the available memory on the machine. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bartman" wrote in message ... I have a workbook that has large amounts of vlookups (about 15,000). My Excel workbook keeps giving me an error message that there are not enough Excel resources and it cannot save external values. Is there a limtation on the number of lookups that can be supported in Excel? Thanks in advance.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Maximum number of rows? | Excel Discussion (Misc queries) | |||
Hybrid Mode
