I am using Excel 2007. I created a drop down list with the source location on
a different tab. The drop down list does not show an error message when an
entry is not part of the list. I have the error alert box checked but I still
can enter data not on the list. Any work around or is this a feature of 2007?

Thanks