Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation not preventing invalid entries
I have Data Validation set up and it is NOT preventing entries that are not
in my data list. I have one sheet with the data list (A1:A15) and the range is named "Category". On the page where I'm wanting the DV, I have Validation to Allow "List" and the Source is "=Category" (without the quotes). Ignore Blank and In-Cell Drop-down are both checked. I get the drop-down boxes with the correct data, but, I can enter ANYTHING in the cells and it is accepted. I have a message that should pop up if an invalid entry is typed in, but it doesn't come up either. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation not preventing invalid entries
What do you have selected on the 'Error Alert' tab?
"Denise" wrote: I have Data Validation set up and it is NOT preventing entries that are not in my data list. I have one sheet with the data list (A1:A15) and the range is named "Category". On the page where I'm wanting the DV, I have Validation to Allow "List" and the Source is "=Category" (without the quotes). Ignore Blank and In-Cell Drop-down are both checked. I get the drop-down boxes with the correct data, but, I can enter ANYTHING in the cells and it is accepted. I have a message that should pop up if an invalid entry is typed in, but it doesn't come up either. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation not preventing invalid entries
Is there a blank cell in the Category range? If so, remove the check
mark from Ignore blank, and it should work correctly. Denise wrote: I have Data Validation set up and it is NOT preventing entries that are not in my data list. I have one sheet with the data list (A1:A15) and the range is named "Category". On the page where I'm wanting the DV, I have Validation to Allow "List" and the Source is "=Category" (without the quotes). Ignore Blank and In-Cell Drop-down are both checked. I get the drop-down boxes with the correct data, but, I can enter ANYTHING in the cells and it is accepted. I have a message that should pop up if an invalid entry is typed in, but it doesn't come up either. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Data Validation, Invalid Data Imput | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
data validation | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) |