software

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 quot;Categoryquot;. On the page where I'm wanting the DV, I have Validation
to Allow quot;Listquot; and the Source is quot;=Categoryquot; (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.

What do you have selected on the 'Error Alert' tab?

quot;Denisequot; wrote:

gt; I have Data Validation set up and it is NOT preventing entries that are not
gt; in my data list. I have one sheet with the data list (A1:A15) and the range
gt; is named quot;Categoryquot;. On the page where I'm wanting the DV, I have Validation
gt; to Allow quot;Listquot; and the Source is quot;=Categoryquot; (without the quotes). Ignore
gt; Blank and In-Cell Drop-down are both checked. I get the drop-down boxes with
gt; the correct data, but, I can enter ANYTHING in the cells and it is accepted.
gt; I have a message that should pop up if an invalid entry is typed in, but it
gt; doesn't come up either.

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:
gt; I have Data Validation set up and it is NOT preventing entries that are not
gt; in my data list. I have one sheet with the data list (A1:A15) and the range
gt; is named quot;Categoryquot;. On the page where I'm wanting the DV, I have Validation
gt; to Allow quot;Listquot; and the Source is quot;=Categoryquot; (without the quotes). Ignore
gt; Blank and In-Cell Drop-down are both checked. I get the drop-down boxes with
gt; the correct data, but, I can enter ANYTHING in the cells and it is accepted.
gt; I have a message that should pop up if an invalid entry is typed in, but it
gt; doesn't come up either.--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html