Microsoft KB Archive/272881

= XL2001: Data Validation Fails When Data Type Is Previously Selected =

Article ID: 272881

Article Last Modified on 1/29/2007

-

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.

Additional query words: off2001kb mac XL2001KB

Keywords: kbbug kbpending KB272881

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.