Data validation problem
Posted by Ian G on April 02, 2001 8:41 PM
I am having trouble getting the data validation function in Excel 97 to work properly.
I have used a named range to define the drop down list source and while that part works OK (ie. the drop down list shows the values in the named range) the error alert is not displayed if a user enters an invalid value, and the invalid value is accepted. This happens whether the invalid value is typed directly into the cell or pasted into the cell.
I have the Show error alert after invalid data is entered check box selected, and it does this whether I enter my own error message or leave everything at the default settings.
However, when I change the list source from a named range to a range of cells (eg. $G$1:$G$5) the validation function works fine.
I have tried this on a couple of spreadsheets with different data and the same thing happens. I have also been through the data validation troubleshooting topic in Excel help and have looked at all the posts on this site I can find about validation but I cant spot anything amiss in what I'm doing.
Am I doing something wrong or is this a bug? Its not a huge problem but I prefer to used ranges where possible and am more than a bit curious as to why its happening.