Forum Discussion
Drop-down not functional
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
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.
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.
I know I don't know anything (Socrates)
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!