Hi!

A data validation drop down list can have 32,767 entries.

Biff

"timboellis" wrote
in message ...

I have a new worksheet setup however, excel will only allow me to enter
so much sata in the drop down validation list.

I need at least tripple the amount that is allowed any way of doing
this.

I even tried putting the list in Open office and that al worked fine
then tried to open it in Excel but excel just deleted the bottom of the
list

Any suggestions


--
timboellis
------------------------------------------------------------------------
timboellis's Profile:
http://www.excelforum.com/member.php...o&userid=25381
View this thread: http://www.excelforum.com/showthread...hreadid=396870