Dan

Have you got "in-cell drop down" un-checked for that particular DV dropdown on
that sheet?


Gord Dibben MS Excel MVP

On Mon, 16 Apr 2007 16:00:01 -0700, Dan S.
wrote:

I have cells with data validation using a list, but suddenly the dropdown
list doesn't appear when the cell is selected. The validation is still
functional, but no dropdown on a specific worksheet. If I create a similar
validation on another sheet in the same book, it works just fine. What's
going on?