Number of dropdown fields in Excel is limited. I need more. How?

U

UweVahrson

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?
 
B

Bob Phillips

Duke Carey said:
How can a user view/use/comprehend anything more than a dozen or so dropdowns
??
Click to expand...

He might have a thousand data entry boxes that all have the same DV applied
to them?
 
O

Otto Moehrbach

What do you mean when you say you can't save the file? What happens when
you try to save the file? Do you get an error message? Are you saving to a
removable disk or to the hardrive? HTH Otto
 
D

Duke Carey

It may be that that's the case, Bob, but I thank my lucky stars I don't have
to use a tool requiring a thousand data entry points.
 
B

Bob Phillips

or create the DV box when the cell is selected.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

I'm with you there :)

Bob


Duke Carey said:
It may be that that's the case, Bob, but I thank my lucky stars I don't have
to use a tool requiring a thousand data entry points.
Click to expand...
 
Top