Home  »  Excel   »   Solve: This value doesn’t match the data validation restrictions defined for this cell

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

By | June 10, 2016

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.

4 thoughts on “Solve: This value doesn’t match the data validation restrictions defined for this cell

  1. Ces20

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

    Reply
  2. Anonymous

    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

    Reply
    1. Sebastian Expert Post author

      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…”

      Reply

Leave a Reply

Your email address will not be published.