Identify source of a dropdown list

Solved
SuperAmbi Posted messages 14 Status Membre -  
SuperAmbi Posted messages 14 Status Membre -
Hello,

I am working on an Excel spreadsheet that has already been modified several times, so I need to do a sort of "refresh."
I have a dropdown list in a table that should display currencies "EUR, USD, YEN, FCFA." Instead, it shows "EUR, #REF!, #REF!, #REF!"
Since I am not the creator of this table, I do not know where these errors come from (I mean, "what is the source of this dropdown list?").
I tried using the "trace precedents" function, but it only works with formulas and not dropdown lists.

Do you know how I can do this? Can you help me?

Thank you in advance! Best regards,

2 réponses

via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

Select the dropdown list cell and then go to the Data tab - Data Validation

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
2
SuperAmbi Posted messages 14 Status Membre 1
 
Thank you very much!
0