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?

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?

Ensure that in the Excel Options-Advanced the Display options for this
workbook has "For all objects show... All" selected, otherwise dropdown lists
will no longer show up.

--
Philip Trick
Actuarial Consultant


"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?