Data validation Drop down not working

[ardykav]

Hi All,

I have set a simple Yes No data validationd drop down on my worksheet. However whenever I go to the cells with it in it I dont get the option to slect yes or no, the little dropdown arrow to the right appears for a split second but then disspears again. However if I hold the left mouse button in the cell the drop down arrow appears but once I let go it dissappears again.

I have used other workbooks in the same session and it works fine. Also if I copy the tab to a new workbook it also works fine. Have also found if I click on another window and go back to the document the drop down stays there, Very strange, Anyone any ideas with this?

 

[Chrisdontm]

Perhaps that sheet is corrupt in some way.
You could copy the info into another worksheet,
Once you are sure it works, then delete that sheet...