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 ...
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
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
- Wow, that was too easy, after the trouble it put me through. Thanks!