Hello Roger,

Yes of course it contains the list values !!!
I am very used to Excel it and this is the very first time that happens to me.

Ant that can't be that because even with a blank range selected, a single
row in cell drop down list appears ;-)

That has only been happening in this sheet, others workbooks and worksheets,
even in the same or a different Excel process, work perfectly !

So really believe meit seems to be much more subtle ;-)

Thx for your enquiry

"Roger Govier" wrote:

Hi

There is no bug that I am aware of.
Are you absolutely sure that the range you have given for the List, is
the range than contains the List values?

--
Regards

Roger Govier


"Patachoup" wrote in message
...
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