Drop-down not functional

[Schmacker]

What would cause a drop-down to not function? I use drop-downs all the time, and haven't had this happen:

Data validation applied to one column on a worksheet. Configured as List, with Source being a named range on another sheet. Yet no drop-down appears.

What am I missing?

[#2]

@Schmacker 

Exactly what you are missing is not possible to comprehend for someone who wants to help.
If I may recommend, attach a file (without sensitive data) and explain your topic based on this file.

It is advantageous if the version of Excel, operating system and storage medium are known.

Drag and drop here or browse files to attach

Maximum size: 71 MB • Maximum attachments allowed: 5

Here is a link that might help you by comparing it to your dropdown.

How to make a dynamic dependent dropdown list in Excel an easy way

Standard disclaimer: none Microsoft website

Thank you for your patience and understanding

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

Hi @Schmacker 

I agree with @NikolinoDE , a sample file would make things easier for us to help.

Apart from that, you could check if you have ticked this option:

Without, the dropdown-arrow would not appear.

[#4]

I don't see how to attach my file to this discussion.

[#5 · Accepted solution]

Hi @Schmacker 

the solution for this strange behaviour is a setting in the advanced Excel options. For whatever reason, this flag "For objects, show:" is set to "Nothing (hide objects)" in your workbook.

Once you set it to "All", the dropdwon arrows will re-appear.

Kind regards,
Martin

[#6]

Wow, that was too easy, after the trouble it put me through. Thanks!