validation

L

Lisa

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
 
P

Peo Sjoblom

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