Forum Discussion
Solved
Drop-down not functional
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?
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
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.
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.
Maximum size: 71 MB • Maximum attachments allowed: 5Here 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.
I know I don't know anything (Socrates)
- I don't see how to attach my file to this discussion.
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
