Microsoft KB Archive/236620

= XL97: Data Validation List Does Not Appear =

Article ID: 236620

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q236620





SYMPTOMS
In Microsoft Excel, when you select a cell that uses data validation that allows a list as a validation criterion, the drop-down list box arrow does not appear.



CAUSE
This problem may occur when the following conditions are true:
 * You are using data validation on a cell that uses a list as a validation criterion.

-and-
 * You are using the freeze panes feature.



WORKAROUND
To work around this problem, unfreeze the window panes. To unfreeze panes, click Unfreeze Panes on the Window menu.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

