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:  Patrick Gibbons (fnkler…@hotmail.com)
Date: Sat, 15 May 2004

As you suspected the freeze panes was the problem . . . that is a silly bug
.. . .  Oh well.

Thank you, now which choice will I use . . .  No matter, I'll figure that
out.  At least now I know what's up.

Thank you again,

Patrick Gibbons

"Dave Peterson" <ec357…@msn.com> wrote in message
news:40A64EA3.C3B7FD…@msn.com...
> 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

None

In response to

Re: Data Validation - Allow List - In-cell Dropdown not showing up posted by Dave Peterson on Sat, 15 May 2004