Validation dropdown list is not available

[Makelei]

Hi,
I have XP and 2003.
Here's my problem: I vae defined to one column validation. As I select one
of the cells, the dropdown list does not come available as usually. I have
had once before the same, but I cannot remember how it can be resolved.

I have tried to make correction with another file. Creating column with
needed validation and it works perfectly. As I copy trhe column to original
file - again same problem - validation dropdown list (the arrow) is not
visible.

I I recall correctly, there is some kind of list function that needs to be
replaced, but cannot remember how...

Thanks in advance
Makelei

 

[Gord Dibben]

Tools>Options>View>Objects "Show All" should be checked.


Gord Dibben MS Excel MVP