Hi folks,

I have a problem with a spreadsheet using data validation. The
validation uses a list with the indirect function and named ranges so
the list is evaluated based on the content of another cell and the
lists themselves are on another sheet. I have used this solution in
many spreadsheets with no problems before. My problem now is that it
just does not work on a particular solution... The list is presented
OK in the drop down, but the user can enter any information just by
typing, no alarms show, even though they are set to. Also the circle
invalid data does not show anything.

Am I loosing my mind here? This one I just can't figure out!

Thanks in advance

M@