How can a user view/use/comprehend anything more than a dozen or so dropdowns
??

If the second dropdown depends on the user's selection in the first
dropdown, then see the advice offered here

http://www.pcmag.com/article2/0,1759,1585456,00.asp


"UweVahrson" wrote:

I need some thousand dropdown fields (via validation function) in Excel. But
if I input too many fields I can't save the file. Seems the number of
dropdown fields is limited. How can I enlarge the number of allowed dropdown
fields? Can I change the setup anyway?