Oct 27 2020 03:10 AM
Oct 27 2020 03:10 AM
I am using Excel 2010 and I have created a data validation cell based on list of values from a set of given values. I am now unable to click on the arrow. I have checked that the in-cell drop down is enabled.
What could have gone wrong. It worked originally until I opened up a copy sent by a team member. Now I am unable to click on the down arrow in the cell. I can see the arrow but when I click on it, it did not bring up the list but instead moved on to the next cell.
Oct 27 2020 04:19 AM
File -> Options -> Advanced-> Group: Show options for this workbook: -> Show objects as: Select "All".
Then the dropdown functions will be back. :)
Ps. Recommend to do an Office update. As far as I can remember, that was an old bug which was actually fixed with a patch in the service pack ... even in 2010. Better safe than sorry, update.
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Oct 28 2020 02:08 AM
@NikolinoDE HI Nikolino,
Sorry, in the Advance Option, there is no Group so I couldnt do what you suggested. And I mistook, my version is not 2010 but 2019 ;)
I ran an update, logoff and relogin but problem still exists.
I wonder if I delete the software and reload with the code, will that work?
Aug 06 2021 04:57 PM
Aug 07 2021 04:26 AM
So with me I can open it, as Mr. Hans Vogelaar also describes it.
You might be lucky with this correction instruction.
In some cases, the arrow of drop down list disappears because the option called In-cell dropdown is not checked.
If all of this does not work out, make a Windows update and an Office update to be on the safe side. If this doesn't work either, then ... halleluia, uninstall and reinstall the office package.
Hope it doesn't come to that and be lucky with the correction instructions.
Nov 16 2021 10:06 AM
Nov 17 2021 11:37 AMSolution
Dec 15 2021 05:14 AM
@Sara Baeten Yes, I can confirm this. I have two screens on a MacBook: a retina screen (dropdowns are working, also on other settings than 100%) and a non-retina screen (dropdowns persistenly not working). Thanks for helping me to find this out, it was driving me crazy.
Jan 18 2022 06:59 AM
I was able to solve this by moving my Excel file to larger monitor. Here's what I did:
1) close the file with the problem (it was displayed on my laptop monitor)
2) close Excel
3) open Excel in a different display (I opened on a large 2nd monitor)
4) open the file
5) the dropdown now worked
Still doesn't work for me if I move the file back to the small monitor...
Apr 22 2022 12:01 PM
I had this problem, I am using two external monitors and my laptop monitor. I tried many of the different approaches mentioned here, all my settings were correct. I had very limited success opening up old versions, but as soon as I saved or updated my data, the dropdown would no longer drop down.
I eventually closed the several excel windows I had open, then opened up the same file from File Explorer and the dropdowns were working again. This was all on the same external monitor, I never tried playing around with display settings.
Dec 02 2022 08:23 AM
Dec 02 2022 08:29 AM
@AMayo1001 Awesome! That does in fact work for me. Can't explain why, but moving the Excel file to the 2nd screen solved the issue. Now that I read (and do) this, I recall having seen this solve some other issue a year or two ago. A good thing to try with future hard to solve Excel "bugs".
Jul 11 2023 07:36 PM
Old post, but this was extremely helpful for an issue I had encountered!
Not sure when the setting changed for me, but this certainly resolved the frustrating issue I had with drop-downs.
For later Excel version Office 365 reference, the navigation is as follows:
File > Advanced:
Under the "Display options for this workbook" sub-header there is the option "For objects, show:"
Jul 11 2023 10:47 PM
Nov 23 2023 11:35 AM - edited Nov 23 2023 11:50 AM
This was an awesome discovery. I did not find the answer until I continued reading.
Mine was working until it wasn't. I realized after read that I had zoomed the workbook. Putting the zoom back to 100%, changing monitors, close/open, copy workbook, clear validation,... nothing worked. Did not find until I got to this post where to find the appropriate section. Question remains, why did it get changed from All to Nothing? Thanks Trahllah.