Excel: Data validation not working

Dear All, I am facing problem regarding Data Validation that when i Type data in data validation activated cell it shows error when i type Data which is not available in my list but when i copy Paste/Paste Special in Same cell it do not show error it just Paste value if it is in my list or Not. I think an error must be displayed while copy pasting data if it is not in my specified List if Source Data... Can anyone Help...

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of March 21, 2014.

For more resources for Microsoft Excel