Drop Down Menu Issue

Corleone

Well-known Member
Joined
Feb 2, 2003
Messages
699
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
 
Last edited:

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,278
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
 
Last edited:

Forum statistics

Threads
1,078,393
Messages
5,339,926
Members
399,340
Latest member
JasonT903

Some videos you may like

This Week's Hot Topics

Top