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.