Share this article
This article is translated in
Improve this guide
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.
More about the topics:Microsoft Excel
Afam Onyimadu
Windows Software Expert
Afam is a geek and the go-to among his peers for computer solutions. He has a wealth of experience with Windows operating systems, dating back to his introduction to Windows 98. He is passionate about technology amongst many other fields. Aside from putting pen to paper, he is a passionate soccer lover, a dog breeder, and enjoys playing the guitar and piano.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Afam Onyimadu
Windows Software Expert
Afam is a geek and the go-to among his peers for computer solutions. He has a wealth of experience with Windows operating systems.