| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
