validation

[Guest]

I set up a validation (drop down box) on the same tab. The dropdown box was
working fine until now. I have checked that excel is on automatic. If I look
at the validation (it's there). However, if I click on the cell I do not get
the right arrow showing there is a dropdown box. I can right click and choose
"pick from drop down list"; however, my the list is not the same. I have
deleted and reenterred it. I have tons of data in the workbook so before I
start over, I wanted to see if anyone has had this problem.

Very confused,
Lisa

 

[Peo Sjoblom]

Select the cell, do data>validation and re-select in cell dropdown, pick
from dropdown list is something else

 

[Gord Dibben]

Tools>Options>View>Objects. Check "Show all"


Gord Dibben MS Excel MVP

 

[Guest]

I've tried both solutions already...neither one works. Any other suggestions?