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

"Gord Dibben" wrote:

ToolsOptionsViewObjects. Check "Show all"


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 10:36:01 -0700, Lisa wrote:

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