XL2001: Data Validation Fails When Data Type Is Previously Selected (272881)


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
This article was previously published under Q272881

SYMPTOMS

When you set the validation criteria for a column in a list, and then type a value that does not meet the validation criteria in a cell in that column, the data is accepted as valid.

CAUSE

This problem occurs when the following conditions are true:
  • You select a data type in the Column Settings dialog box, prior to setting the validation criteria. - and -

  • You select one of the following data types:
    • Whole number
    • Decimal
    • List
    • Date
    • Time
    • Text length

WORKAROUND

To work around this problem, follow these steps:
  1. Click any cell in a list column that is accepting data outside the existing validation criteria.
  2. On the List toolbar, click Column Settings, and then click Validation.
  3. Click the Error Alert tab, and then click to select Show error alert after invalid data is entered. Click OK twice to accept the settings.
This causes a default error message to appear whenever you type a value that does not match the validation criteria in that column.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.

MORE INFORMATION

For more information about using Data Validation in lists, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click L.
  2. Scroll down until you locate list, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click Apply data validation by using the List Manager.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB272881
©2002 Microsoft Corporation. All rights reserved.