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
Highlighted
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

5 Replies
Highlighted

@Jasmine1111 

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

Highlighted

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

Highlighted

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

 

Thanks

Jasmine

Highlighted

@Hans Vogelaar 

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

 

Thanks

Jasmine

Highlighted

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