View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default What is the maximum number of unique strings in Excel 2003

Hi John,
There is no published limit. I suppose that, like many other "limits" one could think of, it depends on how you create them
(formulas? Import? manual entering?) and available memory.
But I downloaded a workbook containing the complete King James' Bible:
http://j-walkblog.com/index.php?/web...ible_in_excel/

You might want to try and explain what you're trying to achieve and what behavior of Excel won't let you

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


wrote in message ups.com...
| On Oct 31, 10:16 am, wrote:
| What is the maximum number of unique strings in Excel 2003?
|
| Given the initial replies, I should clarify:
|
| What is the maximum number of unique strings *supported by* Excel
| 2003?
|
| Adding more than 8,388,479 unique strings appears to make Excel crash.
|
| John.
| --
|
|