I dunno smart guy, it works for me.

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?