What is the maximum number of unique strings in Excel 2003

J

jmcnamara

Hi,

What is the maximum number of unique strings in Excel 2003?

I have estimated it as 2^23-128-1 = 8,388,479.

Is that correct?

Any additional unique strings after that appear to make Excel crash.

John.
--
 
J

jmcnamara

What is the maximum number of unique strings in Excel 2003?
Click to expand...

Just to clarify, that should really read:

What is the maximum number of unique strings *supported by* Excel
2003?

John.
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the maximum number of unique strings in Excel 2003 5
Convert a 8X3 table to a vertical range of the Unique strings only 8
Finding the maximum in an array of strings (Excel VBA) 6
Excel-2007 doesn't sort strings as described in documentation 3
"Maximum Number of fonts exceeded" 2
Find the Largest Integer in Column 4
Excel Counting unique values in Excel, based on criteria. 5
Error generating a list of unique values in range (XL2003) 2

Top