SOLVED

drop down menus

%3CLINGO-SUB%20id%3D%22lingo-sub-2095222%22%20slang%3D%22en-US%22%3Edrop%20down%20menus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095222%22%20slang%3D%22en-US%22%3E%3CP%3EFrom%20some%20reason%2C%20in%20Excel%2C%20I%20am%20no%20longer%20able%20to%20click%20on%20an%20arrow%20and%20get%20drop%20down%20menus%20to%20stay%20open.%26nbsp%3B%20I%20can%20see%20them%20briefly%2C%20but%20they%20go%20away%20before%20I%20can%20click%20on%20my%20selection.%26nbsp%3B%20These%20are%20spreadsheets%20I%20have%20used%20for%20years%2C%20and%20this%20problem%20just%20started.%20I%20have%20tried%20shutting%20down%20and%20re-opening%2C%20and%20opening%20a%20new%20spread%20sheet.%26nbsp%3B%20Problem%20persists.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3F%3F%3F%26nbsp%3B%3CBR%20%2F%3EThanks%20for%20any%20help%20you%20can%20give.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2095222%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095556%22%20slang%3D%22de-DE%22%3ESubject%3A%20drop%20down%20menus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095556%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F942170%22%20target%3D%22_blank%22%3E%40Elizabeth324%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20do%20not%20know%20your%20version%20of%20Excel%20or%20the%20file%20environment.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20don't%20even%20know%20what%20kind%20of%20Excel%20file%20is%20causing%20this%20problem.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ETherefore%20it%20is%20always%20an%20advantage%20if%20you%20insert%20a%20file%20(without%20sensitive%20data)%20and%20explain%20your%20problem.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20it%20reminds%20me%20of%20the%20old%20problem%20with%20the%20Drobox%20or%20OneDrive.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20was%20enough%20to%20close%20Dropbox%2FOneDrive%20via%20the%20task%20manager%20and%20the%20error%20was%20gone.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E(Unfortunately%20only%20permanently%20when%20Dropbox%20is%20uninstalled).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThere%20are%20other%20possible%20causes%2C%20but%20more%20information%20would%20be%20needed.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%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%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095672%22%20slang%3D%22en-US%22%3EBetreff%3A%20drop%20down%20menus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3EThank%20you%26nbsp%3Bfor%20your%20fast%20response.%26nbsp%3B%20I%20thought%20you%20gave%20me%20a%20clue%20when%20you%20mentioned%20Dropbox%2C%20as%20the%20files%20I%20was%20using%20are%20in%20Dropbox.%26nbsp%3B%20But%2C%20I%20opened%20one%20that%20is%20not%20in%20Dropbox%20and%20had%20the%20same%20problem%20there.%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CBR%20%2F%3EI%20don't%20see%20any%20%22about%22%20that%20I%20can%20access%20to%20find%20out%20the%20version%20of%20Excel%20I%20am%20using.%26nbsp%3B%20It's%20part%20of%20my%20subscription%20to%20Microsoft%20365.%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20can't%20post%20a%20picture%20of%20the%20exact%20problem%2C%20because%20the%20dropdown%20box%20disappears%20so%20fast.%26nbsp%3B%20Here's%20a%20file%2C%20that%20is%20not%20in%20dropbox.%20(In%20this%20file%2C%26nbsp%3B%20I%20was%20just%20using%20Excel%20as%20a%20way%20to%20make%20a%20form%20with%20boxes%2C%20no%20formulas%2C%20etc%20involved.)%26nbsp%3B%20Now%20I%20can't%20change%20the%20type%20or%20background%20colors.%26nbsp%3B%20%26nbsp%3BThank%20you%26nbsp%3Bso%20much!%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Elizabeth324_0-1611611303086.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249284i2502CB4796734F1D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Elizabeth324_0-1611611303086.png%22%20alt%3D%22Elizabeth324_0-1611611303086.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095800%22%20slang%3D%22de-DE%22%3ESubject%3A%20drop%20down%20menus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095800%22%20slang%3D%22de-DE%22%3EClose%20Dropbox%20via%20the%20task%20manager%20and%20the%20error%20was%20gone.%20(Unfortunately%20only%20permanently%20when%20Dropbox%20is%20uninstalled).%3CBR%20%2F%3EIf%20you%20already%20do%20this%2C%20try%20this%20option%20before%20uninstalling%20dropbox.%3CBR%20%2F%3E%3CBR%20%2F%3EFile%20-%26gt%3B%20Options%20-%26gt%3B%20Advanced%20-%26gt%3B%20Options%20for%20this%20workbook%20-%26gt%3B%20you%20have%20activated%20under%20show%20objects%20-%26gt%3B%20Nothing%20%3CBR%20%2F%3E%20there%20select%20All%20and%20the%20dropdown%20is%20visible%20if%20this%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20the%20problem.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
New Contributor

From some reason, in Excel, I am no longer able to click on an arrow and get drop down menus to stay open.  I can see them briefly, but they go away before I can click on my selection.  These are spreadsheets I have used for years, and this problem just started. I have tried shutting down and re-opening, and opening a new spread sheet.  Problem persists.      ??? 
Thanks for any help you can give.  

7 Replies

@Elizabeth324 

I do not know your version of Excel or the file environment.

I don't even know what kind of Excel file is causing this problem.

Therefore it is always an advantage if you insert a file (without sensitive data) and explain your problem.

 

But it reminds me of the old problem with the Drobox or OneDrive.

It was enough to close Dropbox/OneDrive via the task manager and the error was gone. (Unfortunately only permanently when Dropbox is uninstalled).

 

There are of course other possible causes, but more information would be needed.

 

Thank you for your understanding and patience

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino 

Thank you for your fast response.  I thought you gave me a clue when you mentioned Dropbox, as the files I was using are in Dropbox.  But, I opened one that is not in Dropbox and had the same problem there.  

I don't see any "about" that I can access to find out the version of Excel I am using.  It's part of my subscription to Microsoft 365.  
I can't post a picture of the exact problem, because the dropdown box disappears so fast.  Here's a file, that is not in dropbox. (In this file,  I was just using Excel as a way to make a form with boxes, no formulas, etc involved.)  Now I can't change the type or background colors.   Thank you so much!  
Elizabeth324_0-1611611303086.png

 

Close Dropbox via the task manager and the error was gone. (Unfortunately only permanently when Dropbox is uninstalled).
If you already do this, try this option before uninstalling dropbox.

File -> Options -> Advanced -> Options for this workbook -> you have activated under Show objects -> Nothing
there select All and the dropdown is visible, if was this the problem :).

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

@Nikolino 
Thanks again for your help!  I did check the "All" box under "show objects".  "All" was selected.  I unselected and re-selected it. Didn't make any difference.  I got disgusted and didn't use Excel for a day.  Today, it's working just fine! 
I tend to think of computers as "magic", since I don't really understand them.  Thanks for waving your magic wand in my direction!  

Which Excel version are you using exactly? ...and Computer Operationsystem.

Could you include any of the files (with no sensitive data) that have this problem?

There can be so many things, I don't have the experience that I can solve the problem immediately with a picture or give you a suggested solution.

Thank you for your patience and time.


Nikolino
I know I don't know anything (Socrates)
Problem is solved. Thanks again.
Best Response confirmed by Elizabeth324 (New Contributor)
Solution
I am happy that I was able to help you

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.