issues about excel drop-down list

[hunter8199]

Hi guys

I encountered a interesting problems.

In Excel, you push a list of data into drop-down list, the length of list has limit. Do you know some solution to break this limitation?

many thanks!

[Simon Lloyd]

Hi i have just created a drop down list in a cell where i can access 5000 entries i didnt bother putting more test data than that in...............how many entries do you need?

Regards,
Simon