Drop Down Menu Issue

[Corleone]

Hi
I have a spreadsheet containing a dropdown menu
There has never been an issue using it in the past, however we have recently upgraded to 2016 and when i click on it now
the drop_down arrow quickly appears then disappears again.

In other tabs within the same spreadsheet , the dropdowns all work fine

any ideas why this is?

Thanks

 

[Yongle]

Ooooops?
Check that data validation criteria is valid - try editing the DV (something critical may have been unwittingly amended somewhere)

VBA?
Is DV created by VBA? - post your code

Corruption?
Could be a minor corruption in the errant sheet (especially if only happening in ONE sheet in ONE workbook) - try creating a new sheet with same data validation