Re: Data Validation - Allow List - In-cell Dropdown not showing up

Giganews Newsgroups
Subject: Re: Data Validation - Allow List - In-cell Dropdown not showing up
Posted by:  Dave Peterson (ec357…@msn.com)
Date: Sat, 15 May 2004

Are you using windows|freeze panes?

Is your cell with Data|validation above that line?

If yes, move the cell or remove the data|validation.

It's a bug in xl97, fixed in xl2k.

Patrick Gibbons wrote:
>
> This is in a MS Office 97 Excel Workbook, although I have selected data
> validation for a cell the in-cell dropdown is not showing up.  Of course
> some silly person would tell me that I don't have the In-cell Dropdown
> checkbox selected . . . got it smart guy.  It is still not working.
>
> I will give you the current setup:
>
> Cell L4 has the current data validation:
>    Allow: List
>    Source: =$B$54:$B$65
>    Ignore blank - selected
>    In-cell Dropdown - selected
>
> Cells B54:B65
>    January
>    February
>    March  . . . etc.
>
> Anyone have any ideas?

--

Dave Peterson
ec357…@msn.com

Replies

In response to

Data Validation - Allow List - In-cell Dropdown not showing up posted by Patrick Gibbons on Sat, 15 May 2004