"This value doesn't match the data validation restrictions"
The cell carries a rule (a list, a number between two limits, a date) and the value typed does not meet it. Excel refuses the entry.
What the message says
Data validation limits what a cell accepts. When the value does not meet it, Excel stops it with this message, or with the one the workbook's author wrote.
Why it appears
- A drop-down list: the value must be one of the list's, spelling and spaces included.
- A number or a date outside the limits set.
- A text longer than allowed.
- A list whose source was deleted or points to another, closed workbook.
Making it go away
- Data, Data Validation: the cell's rule can be read and changed there.
- For a list, pick the value from the arrow rather than typing it.
- A paste bypasses validation silently: the rule only protects typing.
The tool that handles it
To check a whole file before importing it into software, with its own rules (required columns, lengths, allowed values), Pre-import check says row by row what will be rejected; Validate data checks IBANs, email addresses and dates.
Frequently asked questions
- Why are invalid values in the file anyway?
- Because they were pasted or imported: validation only applies to typing.