|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
> March . . . etc.
> Anyone have any ideas?
Data Validation - Allow List - In-cell Dropdown not showing up posted by Patrick Gibbons on Sat, 15 May 2004