Solved: This value doesn’t match the data validation restrictions defined for this cell

7
Please wait...

When you try to input some value in a cell and you get an error message in Excel 2016:

This value doesn't match the data validation restrictions defined for this cell.
Excel 2016 - This value doesn't match the data validation restrictions defined for this cell.

or in Excel 2013:

The value you entered is not valid. A user has restricted values that can be entered into this cell.
Excel 2013 - The value you entered is not valid. A user has restricted values that can be entered into this cell.

This means that someone has set Data Validation on that cell. To view its configuration and remove if needed follow these steps:

  1. Select cell and go to Data -> Data Validation
    Depending on the size of the window you access it in a bit different way.
    Please look at the screenshots below:

    Excel - Data -> Data Validation - Narrow Size Window. Click to enlarge.
    Excel - Data -> Data Validation - Narrow Size Window. Click to enlarge.
    Excel - Data -> Data Validation - Middle Size Window. Click to enlarge.
    Excel - Data -> Data Validation - Middle Size Window. Click to enlarge.
    Excel - Data -> Data Validation - Wide Size Window. Click to enlarge.
    Excel - Data -> Data Validation - Wide Size Window. Click to enlarge.
  2. You will see Data Validation window. Look into Settings tab, Validation criteria section.
    If you want to disable validation, select Any value in Allow drop down and accept by clicking OK.

    Excel - Data Validation Window - Settings - Criteria.
    Excel - Data Validation Window - Settings - Criteria. Click to enlarge.

Related articles

7 Comments
  1. Anonymous says

    KUDOS! TO YOU GUYS! PROBLEM SOLVED

  2. Anonymous says

    Are you actually retarded?
    How is this “solving an error”??
    Data Validation is probably in most cases working exactly as intended, and your “solution” is to turn it off?? FMD

    1. Sebastian Expert says

      Main solution is to check what kind of validation is configured so correct value can be entered.
      Description of disabling validation is an option for some users if needed as text states: “If you want to disable validation…”

    2. Anonymous says

      Why would you be so obtuse and rude? Let me lay down some scenarios for you. What if you like the format of the excel spreadsheet and didn’t need the data validation, what if someone started the creation of the spreadsheet and left the company before finishing it? What if………? It’s really sad that such a benign Q and A on a site that is meant to be informative and helpful can TRIGGER such a negative response. Be helpful or be quite.

      1. Sebastian Expert says

        thank you for the comment

  3. Ces20 says

    THANK YOU SO MUCH!!! I was struggling with this at work trying to fix it. This post is G O L D

  4. rama says

    thanks man- that was usefull

Leave A Reply

Your email address will not be published.