Is there a limit to how far excel will search a list for autocomplete?

[Bluejay]

Auto complete doesn't work for my entire list of 4200 rows. List has
no empty cells, sorted alphabetically and all upper case. Is there
something wrong with my list or is there a limit to the list length?

 

[Pete_UK]

Yes, I did some investigations some years ago and discovered that
there were limits, but I can't remember what they were and I haven't
been able to retrieve the post with the details in.

Hope this helps.

Pete

 

[Pete_UK]

Typical - you find it after you post !!

Check out this link:

http://groups.google.com/group/micr...ocomplete+limits+group:*excel*+author:Pete_UK

Hope this helps,

Pete

 

[Bluejay]

It answers my question, but how am I going to get auto complet for
ther other 4000 entries?