Cant click on drop down arrow

%3CLINGO-SUB%20id%3D%22lingo-sub-1822236%22%20slang%3D%22en-US%22%3ECant%20click%20on%20drop%20down%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822236%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%202010%20and%20I%20have%20created%20a%20data%20validation%20cell%20based%20on%20list%20of%20values%20from%20a%20set%20of%20given%20values.%26nbsp%3B%20I%20am%20now%20unable%20to%20click%20on%20the%20arrow.%26nbsp%3B%20I%20have%20checked%20that%20the%20in-cell%20drop%20down%20is%20enabled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20could%20have%20gone%20wrong.%26nbsp%3B%20It%20worked%20originally%20until%20I%20opened%20up%20a%20copy%20sent%20by%20a%20team%20member.%26nbsp%3B%20Now%20I%20am%20unable%20to%20click%20on%20the%20down%20arrow%20in%20the%20cell.%26nbsp%3B%20I%20can%20see%20the%20arrow%20but%20when%20I%20click%20on%20it%2C%20it%20did%20not%20bring%20up%20the%20list%20but%20instead%20moved%20on%20to%20the%20next%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJasmine%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1822236%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822273%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20click%20on%20drop%20down%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F847238%22%20target%3D%22_blank%22%3E%40Jasmine1111%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20works%20OK%20for%20me.%20Does%20the%20problem%20persist%20if%20you%20quit%2C%20then%20restart%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822403%22%20slang%3D%22de-DE%22%3ESubject%3A%20Cant%20click%20on%20drop%20down%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822403%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F847238%22%20target%3D%22_blank%22%3E%40Jasmine1111%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EExcel%202010%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EFile%20-%26gt%3B%20Options%20-%26gt%3B%20Advanced-%26gt%3B%20Group%3A%20Show%20options%20for%20this%20workbook%3A%20-%26gt%3B%20Show%20objects%20as%3A%20Select%20%22All%22.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EThen%20the%20dropdown%20functions%20will%20be%20back.%3C%2FSPAN%3E%20%3CSPAN%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%20Ps.%20Recommend%20to%20do%20an%20Office%20update.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EAs%20far%20as%20I%20can%20remember%20that%20was%20an%20old%20bug%20which%20was%20actually%20fixed%20with%20a%20patch%20in%20the%20service%20pack%20...%20even%20in%202010.%20Better%20safe%20than%20sorry%2C%20update.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

HI,

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

 

Thanks

Jasmine

7 Replies

@Jasmine1111 

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

@Jasmine1111 

 

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.

 

Nikolino

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.

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

 

Thanks

Jasmine

@Hans Vogelaar 

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

 

Thanks

Jasmine

@Jasmine1111 

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?

I am having the same problem, and have ruled out all the potential causes in all available help documentation. This appears to be a system bug, from it's inconsistent behavior on my machine, in unrelated files and different data validation source types.
Microsoft makes it so impossible to report bugs, that we all are wasting hours trying to get to the bottom of what is probably a known issue 🤦‍

@Jasmine1111 

So with me I can open it, as Mr. Hans Vogelaar also describes it.

You might be lucky with this correction instruction.

 

How to show drop down list’s disappeared arrows again in Excel?

In some cases, the arrow of drop down list disappears because the option called In-cell dropdown is not checked.

  1. Select the drop down list cells and click Data > Data Validation.
  2. In the Data Validation dialog, under Settings tab, go to check In-cell dropdown option.
  3. Clock OK to close dialog, and you can see the arrow of drop down list has been shown.

 

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.