Data validation is not at all foolproof. Refer the below link on data
validation.. Take a look at the links provided at the bottom of this page

From Debra Dalgleish
http://www.contextures.com/xlDataVal01.html

If this post helps click Yes
---------------
Jacob Skaria


"Christopher Naveen" wrote:

Hi,

I am creating a list using data validation in a particular cell. I am facing
following problems and i request anyone of you to help me on this.

1) How can protect the list in the particular cell. If i copy the data from
other cell (where there is no validation) and paste in the validation cell
then the list will be removed
2) Sometimes if i enter free text in the list it accepts not throwing error.

Requesting you to guide me to fix this issue.

Christ