Data Validation

[Jamal]

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.

 

[Gord Dibben]

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

http://www.contextures.on.ca/xlDataVal08.html#ArrowsNotVisible

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