I have data validation on two sheets in a single workbook. On one sheet, the
data validation dropdown does not appear when the cell is clicked. However,
on the second sheet the drop down appears. I have checked the incell dropdown
option. How can I solve this? Thanks for your help.

See Debra Dalgleish's site for possible problems and solutions.

http://www.contextures.on.ca/xlDataV...rowsNotVisible

Since you can see the dropwdown on one sheet but not the other, I would tend
to rule out the "hidden objects" because that is a Workbook setting,. not
just a sheet or window setting.


Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 09:28:11 -0800, Jamal
wrote:

I have data validation on two sheets in a single workbook. On one sheet, the
data validation dropdown does not appear when the cell is clicked. However,
on the second sheet the drop down appears. I have checked the incell dropdown
option. How can I solve this? Thanks for your help.