Fix: This Value Doesn’t Match the Data Validation

Turning off Data Validation should be effective for most readers

3 min. read

Updated onSeptember 17, 2024

updated onSeptember 17, 2024

Share this article

This article is translated in

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

The errorthis value doesn’t match the data validationtypically happens for one of these reasons: the data type is incorrect, the value is out of range, the entry isn’t listed as a valid option, or the format is wrong.

Below, we explain a few ways in which you can fix it:

Howto fixthis value doesn’t match the data validation?

1. Remove data validation

2. Turn off Error Alert

3. Edit the acceptable data

4. Verify cell format

5. Check for hidden data validation

Hidden data validation can also cause issues. By checking and adjusting validation rules, conditional formatting, and named ranges, you can fix these errors and prevent them from happening again.

Excel has no specified limits for data values; however, you should be mindful of the following:

If you have read this far, you should no longer get the error message thisvalue doesnt match the data validation.

Additionally, you might want to check out our other guide if you get the error notificationExcel has run into an error.

We hope the steps above helped you sort out theThis value doesn’t match the data validationerror in Excel. If you have any more questions, feel free to ask us in the comments below.

Fix: This Value Doesn’t Match the Data Validation#

Howto fixthis value doesn’t match the data validation?#

1. Remove data validation#

2. Turn off Error Alert#

3. Edit the acceptable data#

4. Verify cell format#

5. Check for hidden data validation#