G
Guest
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
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