it is working fine, but there is no validation, its showing the list,
but there is no validation, I can type any thing in the data
validation cell. which is not required.


If I give the range in the Source field in the data validation dialog
box, then it is working correctly, if I put the formula which is
=list, then it is not working.


I hope that you understand my problem, or if you have any

I also checked Arrer Alert Tab, the check is Tiked.

I am facing this problem only this file, If I made the same function
in new file then it is working.

Regards.


Shahzad