Cant click on drop down arrow

New Contributor


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.


Please advise




5 Replies


It works OK for me. Does the problem persist if you quit, then restart Excel?



Excel 2010:
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.

@Nikolino 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?




@Hans Vogelaar 

Yes it does.  I also ran an update.  However, I mistook the version, It is 2019 instead of 2010.  





If the workbook is currently open, close it.

Right-click the .xlsx file in File Explorer.

Select Properties from the context menu.

Is there an 'Unblock' check box? If so, tick this check box.

Click OK.

Does that help?