Excel data verification error: Solution to "This value does not match data verification"

Many Excel users may encounter an error message that "This value does not match data verification". This error is related to Excel's data verification capabilities. This article will provide several simple and effective solutions.

"This value does not match data verification" error detailed explanation

The data verification function ensures the integrity of the data type and forces the user to enter valid data within the selected range. However, when you try to enter a value that does not meet the criteria set by the cell, you may receive the following error message:

• This value does not match the data validation limit defined for this cell.
• The value you entered is invalid. The user has been restricted from entering the value of this cell.

To resolve the "This value does not match data verification" error in Excel, we provide the following solutions:

Solution

Method 1: Remove data verification

First, try removing the data verification to see if the problem is resolved.

Step 1: Start Microsoft Excel.

Step 2: Go to the Data menu and select Data Verification.

Step 3: In the Data Verification window, click Clear All.

Step 4: Enter some data to see if the problem still exists.

Method 2: Edit acceptable data

Editing acceptable data is also an effective way to resolve the "this value does not match the data verification" error.

Step 1: Start Microsoft Excel and select the cell where the error occurs.

Step 2: Under the "Data" menu, click "Data Verification".

Step 3: Under the Settings tab, adjust all necessary parameters to suit the data values ??you entered, and click OK to save the changes.

Method 3: Turn off the table data settings

Try turning off the table data settings.

Step 1: Click the arrow icon in the error prompt and click the "Error Check" option.

Step 2: Go to the Formula category and scroll down to find the Error Check Rules section.

Step 3: Uncheck "Invalid data entered in the table", and then click "OK".

Method 4: Close the error message

If the error message still appears repeatedly after trying all of the above methods, you can manually close the error message.

Step 1: Select the cell where the data verification error occurs.

Step 2: Go to Data > Data Tools > Data Verification.

Step 3: Under the Error Warning tab, uncheck "Show Error Warning after entering invalid data".

Summarize

Hopefully the above solution can help you resolve the Excel error of "This value does not match data verification". Have a happy use!

The above is the detailed content of Effortless Fixes: This Value Doesn't Match the Data Validation. For more information, please follow other related articles on the PHP Chinese website!