Microsoft Excel: This Value Doesn’t Match the Data Validation

This Value Doesn’t Match the Data Validation

The data validation feature allows you to ensure the data type integrity by forcing you to enter valid data from the range you have been selected off. However, when you are attempting to enter a value into a cell that doesn’t meet the criteria that you or other users have set for that cell, you might receive the error messages below:

• This value doesn’t match the data validation restrictions defined for this cell.
• The value you entered is not valid. A user has restricted values that can be entered into this cell.

To help you tackle the this value doesn’t match the data validation error in Excel, we have tried our best to come up with some viable solutions for you. Scroll down to get more details now!

MiniTool Power Data Recovery FreeClick to Download100%Clean & Safe

How to Fix This Value Doesn’t Match the Data Validation on Windows 10/11?

Fix 1: Remove Data Validation

First, you can remove data validation to see if it works for this value doesn’t match the data validation.

Step 1. Launch Microsoft Excel.

Step 2. Go to the Data menu and choose Data Validation.

Step 3. In the Data Validation window, click on Clear All.

Step 4. Input some data to see if this issue persists.

Fix 2: Edit the Acceptable Data

To deal with this value doesn’t match the data validation, editing the acceptable data is also applicable. To do so:

Step 1. Launch Microsoft Excel and then select the cells that you receive the error.

Step 2. Under the Data menu, press Data Validation.

Step 3. Under the Settings tab, adjust all the needed parameters to accommodate your entered data value and click on OK to save the changes.

Fix 3: Turn off Table Data Setting

You can also try turning off table data settings. Here’s how to do it:

Step 1. Click on the arrow icon present on the error alert and hit the error checking option.

Step 2. Go to the formula category and scroll down to find Error Checking Rules section.

Step 3. Uncheck Data entered in a table is invalid and hit OK.

Fix 4: Turn off Error Messages

If this error message appears repeatedly after trying all the solutions above, you can turn off error messages manually. Here’s how to do it:

Step 1. Select the cell you receive the data validation error.

Step 2. Go to Data > Data Tools > Data Validation.

Step 3. Under the Error Alert tab, untick Show error alert after invalid data is entered.

How to Fix AutoSave Not Working in Microsoft Office?

What to do when the Autosave feature is not working or grayed out in Microsoft Office? To get the solutions, keep reading.

Read More

Bottom Line

Sincerely hope that you can resolve the this value doesn’t match the data validation error after following the solutions mentioned above. Have a nice day!