Dropdown list that disappears after closing the Excel document Solved

Question

Hello everyone,  I'm writing this message because I have a problem with an Excel document.  When I close my Excel document and open it again, the drop-down lists I created (using the data validation tool) disappear... However, my conditional drop-down lists do not disappear... Just so you know, I'm using Excel 2016.  If you could help me, that would be great, as this is a real issue for me since it's a work document that I use regularly.

Julia1049 · Accepted Answer

Thank you for your help, but through perseverance, I managed to find a solution.  The problem was that the button that allows the dropdown list to appear was not showing anymore.  The solution I found is as follows:  Instead of making a classic dropdown list with a formula like "=Listes!$G$3:$G$8" that retrieves data from another Excel sheet named "Listes", I named the cells that contained the information I wanted. For example, I named it "Etape_du_cycle_de_vie" and then in data validation, I wrote "=Etape_du_cycle_de_vie" to display the dropdown list.  Here is a link to a simplified Excel folder to represent the solution I found:  https://www.cjoint.com/c/GErudGopNUg

Raymond PENTIER · Answer

In order to try to find an explanation, you would first need to explain to us the difference you make: "the drop-down lists I had created (with the data validation tool) disappear... On the other hand, my conditional drop-down lists do not disappear".  -- Retirement is great! Especially in the Caribbean... :-)Raymond (INSA, AFPA, CF/R)

Julia1049 · Answer

Hello Raymond,  For me, a drop-down list is a classic drop-down list that you will create using the data validation tool, by selecting a list of data from another Excel sheet.  Whereas the conditional drop-down list will have content that varies depending on the content of another drop-down list.  For example, I have a drop-down list of "aspect categories" with waste, atmospheric emissions, etc., and the conditional drop-down list will display "CO, CO2, dust, etc." if I choose atmospheric emissions or "plastic, paper, cardboard, etc." if I choose waste.  I have no problem with these last two linked lists.  However, I have other drop-down lists, and it's these that are disappearing.  I hope I was clear!

Raymond PENTIER · Answer

Ah! So you want to talk about cascading dropdown lists...  There is no reason for dropdown lists to "disappear"... But do you mean that the buttons to activate the cascading dropdowns are no longer displaying, or that when you click on these buttons, an empty list unfolds? In the latter case, does the source (in the Data Validation window) contain a formula with the OFFSET function?  Having an Excel file would make it easier for us to analyze and diagnose your problem...  1) Go to https://www.cjoint.com/  2) Click on [Browse] to select your file (max 15 MB) 3) Scroll down to click on the blue button [Create Cjoint link]  4) After a few seconds, the second page will display with the link in bold; right-click on it and choose "Copy link" 5) Return to your discussion on CCM, and in your message, do "Paste".=>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers  -- Retirement is great! Especially in the Caribbean... :-) Raymond (INSA, AFPA, CF/R)

Julia1049 · Answer

I don't know what was deleting the dropdown list I had created...  I somewhat worked around the problem by creating my dropdown list in a different way.

Dropdown list that disappears after closing the Excel document

5 answers

Surface pro 4 tablet fully stuck, what to do ??

Unable to download

Uninstall totaladblock

Sony wh-1000xm5 not turning on after getting wet

Google photos transfer

Broken black screen with talkback enabled and other issues help

Bounced emailsblocked emails

Canon mg6450 printer driver

Texture issues in enshrouded

What to buy for summer 2026