validation
 

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

validation
 

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


--
Regards,

Peo Sjoblom



"Lisa" wrote in message
...
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

validation
 

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

validation
 

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