PC Review


Reply
Thread Tools Rate Thread

Data Validation List (Drop Down) Not Showing

 
 
Dave
Guest
Posts: n/a
 
      13th Jan 2010
I have a validation with drop down list in it but the drop down is not
showing. I can go into the cells with the validation and it shows that it is
set up to be a validation with list. The source of the list is correct. The
drop down worked at one point but now it doesn't. Did I format the cells in
a way that does not allow for validations with lists?

Any help is appreciated. I have been fighting with this off and on all day.
Thanks
 
Reply With Quote
 
 
 
 
Homey
Guest
Posts: n/a
 
      13th Jan 2010
check you have option to show objects turned on. in excel 2003 it in View
section of excel options.


"Dave" <(E-Mail Removed)> wrote in message
news:E9C6B055-DDE2-4FAF-94C1-(E-Mail Removed)...
|I have a validation with drop down list in it but the drop down is not
| showing. I can go into the cells with the validation and it shows that it
is
| set up to be a validation with list. The source of the list is correct.
The
| drop down worked at one point but now it doesn't. Did I format the cells
in
| a way that does not allow for validations with lists?
|
| Any help is appreciated. I have been fighting with this off and on all
day.
| Thanks

 
Reply With Quote
 
zvkmpw
Guest
Posts: n/a
 
      13th Jan 2010
> check you have option to show objects turned on. in excel 2003 it in View
> section of excel options.


I have the same problem with a particular workbook, but not with
others. It's Excel 2003.

For View>Objects, "show all" is selected.

Under Data>Validation, "In-cell drop-down" is selected.

Anything else that should be examined to bypass the problem?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Data Validation List not showing Otto Moehrbach Microsoft Excel Discussion 6 23rd Apr 2008 07:44 AM
Data Validation drop down not showing and Formula Auditing bar greyedout Sean Brown Microsoft Excel Discussion 2 1st Feb 2008 05:35 PM
Re: Why isn't the drop down showing using data validation? Peo Sjoblom Microsoft Excel Worksheet Functions 0 5th Jan 2007 11:40 PM
Data validation not showing drop down =?Utf-8?B?TGlseQ==?= Microsoft Excel Worksheet Functions 1 1st Apr 2005 07:13 PM
Data validation Drop Down Box not showing Dave Microsoft Excel Worksheet Functions 7 17th Jul 2003 05:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:35 AM.