Hello,

I use data validation tool the basic way, LIST setting as validation
criteria and SOURCE range in the same worksheet. I do not use any static or
dynamic named ranges.

The problem is that no dropdown list is displaying anymore. I correctly have
the data validation message in my cell in case I input wrong data which is
not in my SOURCE range, but I do not see any more the drop down list when I
select the cell...

Of course the IN CELL DROPDOWN option is ticked ! But it seems not to work
anymore :(

It comes from this workbook only, because it works properly and as usual in
a new one.

I compared the Options settings, view settings, tried to lock/unlock all
cells and already restarted the CPU but nothing...I must have missed
something !

Please help ! Is it a known bug, or just an option to tick I missed ?

Thx