XL97: Data Validation List Does Not Appear (236620)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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.

REFERENCES

For more information about freezing panes, click Contents and Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text

panes

and then double-click the selected text to go to the "Restore a split window to a single pane" topic. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:8/27/2002
Keywords:kbbug KB236620
©2002 Microsoft Corporation. All rights reserved.