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

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?

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
ec35720@msn.com

I think Dave meant,... "or remove the freeze panes"

You could use Window>Split instead

Dave Peterson wrote:
> 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?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Yes, I did. I was distracted by some XSPAM problems.



Debra Dalgleish wrote:
>
> I think Dave meant,... "or remove the freeze panes"
>
> You could use Window>Split instead
>
> Dave Peterson wrote:
> > 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?
> >
> >
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html

--

Dave Peterson
ec35720@msn.com

If you didn't use your real email address in the public newsgroups,
maybe you wouldn't get so much XSPAM!

Dave Peterson wrote:
> Yes, I did. I was distracted by some XSPAM problems.
>
>
>
> Debra Dalgleish wrote:
>
>>I think Dave meant,... "or remove the freeze panes"
>>
>>You could use Window>Split instead
>>
>>Dave Peterson wrote:
>>
>>>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?
>>>
>>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" <ec35720@msn.com> wrote in message
news:40A64EA3.C3B7FD43@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
> ec35720@msn.com

My name Jose Jimenez.
(apologies to Bill Dana)

or....

mmmmm. XSPAM.
(apologies to Homer Simpson)

Debra Dalgleish wrote:
>
> If you didn't use your real email address in the public newsgroups,
> maybe you wouldn't get so much XSPAM!
>
> Dave Peterson wrote:
> > Yes, I did. I was distracted by some XSPAM problems.
> >
> >
> >
> > Debra Dalgleish wrote:
> >
> >>I think Dave meant,... "or remove the freeze panes"
> >>
> >>You could use Window>Split instead
> >>
> >>Dave Peterson wrote:
> >>
> >>>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?
> >>>
> >>>
> >>--
> >>Debra Dalgleish
> >>Excel FAQ, Tips & Book List
> >>http://www.contextures.com/tiptech.html
> >
> >
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html

--

Dave Peterson
ec35720@msn.com

Hi Debra
this is one of the nice things with NG :-)
You have to constantly adapt your filters :-(

On a sidenote: though in english NG it's o.k. to use false email
addresses in most German NGs (like the German Excel NG) this is
considered against the rules (same is true for not using real names)




"Debra Dalgleish" <dsd@contexturesXSPAM.com> schrieb im Newsbeitrag
news:40A65532.9070209@contexturesXSPAM.com...
> If you didn't use your real email address in the public newsgroups,
> maybe you wouldn't get so much XSPAM!
>
> Dave Peterson wrote:
> > Yes, I did. I was distracted by some XSPAM problems.
> >
> >
> >
> > Debra Dalgleish wrote:
> >
> >>I think Dave meant,... "or remove the freeze panes"
> >>
> >>You could use Window>Split instead
> >>
> >>Dave Peterson wrote:
> >>
> >>>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?
> >>>
> >>>
> >>--
> >>Debra Dalgleish
> >>Excel FAQ, Tips & Book List
> >>http://www.contextures.com/tiptech.html
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

That's why I don't post in the German newsgroups!

And even with a munged address, I need MailWasher to filter all the
messages that arrive.

Frank Kabel wrote:
> Hi Debra
> this is one of the nice things with NG :-)
> You have to constantly adapt your filters :-(
>
> On a sidenote: though in english NG it's o.k. to use false email
> addresses in most German NGs (like the German Excel NG) this is
> considered against the rules (same is true for not using real names)
>
>
>
>
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> schrieb im Newsbeitrag
> news:40A65532.9070209@contexturesXSPAM.com...
>
>>If you didn't use your real email address in the public newsgroups,
>>maybe you wouldn't get so much XSPAM!
>>
>>Dave Peterson wrote:
>>
>>>Yes, I did. I was distracted by some XSPAM problems.
>>>
>>>
>>>
>>>Debra Dalgleish wrote:
>>>
>>>
>>>>I think Dave meant,... "or remove the freeze panes"
>>>>
>>>>You could use Window>Split instead
>>>>
>>>>Dave Peterson wrote:
>>>>
>>>>
>>>>>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?
>>>>>
>>>>>
>>>>--
>>>>Debra Dalgleish
>>>>Excel FAQ, Tips & Book List
>>>>http://www.contextures.com/tiptech.html
>>>
>>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Microsoft recently came out with an advisory telling folks TO use bollixed
email addresses in ng's because of the spam problem.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:OPijWVqOEHA.640@TK2MSFTNGP12.phx.gbl...
> Hi Debra
> this is one of the nice things with NG :-)
> You have to constantly adapt your filters :-(
>
> On a sidenote: though in english NG it's o.k. to use false email
> addresses in most German NGs (like the German Excel NG) this is
> considered against the rules (same is true for not using real names)
>
>
>
>
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> schrieb im Newsbeitrag
> news:40A65532.9070209@contexturesXSPAM.com...
> > If you didn't use your real email address in the public newsgroups,
> > maybe you wouldn't get so much XSPAM!
> >
> > Dave Peterson wrote:
> > > Yes, I did. I was distracted by some XSPAM problems.
> > >
> > >
> > >
> > > Debra Dalgleish wrote:
> > >
> > >>I think Dave meant,... "or remove the freeze panes"
> > >>
> > >>You could use Window>Split instead
> > >>
> > >>Dave Peterson wrote:
> > >>
> > >>>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?
> > >>>
> > >>>
> > >>--
> > >>Debra Dalgleish
> > >>Excel FAQ, Tips & Book List
> > >>http://www.contextures.com/tiptech.html
> > >
> > >
> >
> >
> > --
> > Debra Dalgleish
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
> >
>