XL97: Data Validation Is Only Accurate with Manual Entry

Last reviewed: February 23, 1998
Article ID: Q159403

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, cells to which you apply data validation restrictions (using the Validation command on the Data menu) may accept invalid values.

CAUSE

This behavior occurs when any of the following conditions are true:

You select a range of cells that includes a cell to which you applied data validation restrictions, type an invalid data value, and then press CTRL+ENTER.
These steps insert the value you typed into all the selected cells.
```
    -or-
```
You programmatically insert an invalid value into a cell to which you applied data validation restrictions.
```
    -or-
```
You copy an invalid value from a cell and paste it into a cell to which you applied data validation restrictions.
```
    -or-
```
You drag an invalid value from a cell to a cell to which you applied data validation restrictions.
```
    -or-
```
You use the AutoFill feature to fill an invalid value into a cell to which you applied data validation restrictions.
```
    -or-
```
You are using a Data Form.

NOTE: If you copy, drag, or fill an invalid value to a cell to which you applied data validation restrictions, the data validation restrictions are removed from the cell.

When you apply data validation restrictions on a cell, Microsoft Excel 97 only validates the data when you manually type the value into the cell.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

The ability to specify what data is valid for individual cells or cell ranges is a new feature in Microsoft Excel 97. This feature allows you to do the following:

Create a list of the entries that restrict the valid data values
Create a prompt that explains the type of data that is valid for a given cell
Create a message that appears when incorrect data is typed
Check for incorrect entries using the Auditing toolbar
Set a range of numeric values that can be entered into a cell
Determine if an entry is valid based on a calculation in another cell

REFERENCES

For more information about data validation, click the Index tab in Microsoft Excel Help, type the following text

   data validation, restriction options

and then double-click the selected text to go to the "Types of data restrictions" topic.

Additional query words: XL98
Keywords : xlformat xlformula xlui
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 23, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.