Data Validation

G

Guest

I've got a large spreadsheet (2mb) which has many empty forms repeated with
lots of dropdown list validations - I know, it should be a database really
(don't go there).

For some reason, the data vailidation is now not working which is essential
as it is for others to complete. The drop downs are appearing but it is now
possible to type anything in the validated cells even though there is a stop
error alert message checked for them if non list items are input.

Any ideas or is this just corrupt?
 
D

Debra Dalgleish

There may be a blank cell in the range that contains the items for the
data validation dropdown list.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Error 1
2007 data validation not working 1
Data Validation List: Text Size Query 2
Data validation 1
Data Validation Dropdown List Not Working 4
Validation list in data entry form 4
Excel 2003 Data Validation 2
Data Validation 2

Top