Some of you might run into the issue notification this value doesnt match the data validation in Microsoft Excel.
This error is connected to data validation.
This post fromMiniTool Websitecovers details on how to fix this issue easily.
Scroll down to get more details now!
Go to theDatamenu and chooseData Validation.
In theData Validationwindow, click onClear All.
Input some data to see if this issue persists.
To do so:
Step 1.
Launch Microsoft Excel and then choose the cells that you receive the error.
Under theDatamenu, pressData Validation.
Go to the formula category and scroll down to findError Checking Rulessection.
UncheckData entered in a table is invalidand hitOK.
Heres how to do it:
Step 1. choose the cell you receive the data validation error.
Go toData>Data Tools>Data Validation.
Under theError Alerttab, untickShow error alert after invalid data is entered.
What to do when the Autosave feature is busted or grayed out in Microsoft Office?
To get the solutions, keep reading.
Have a nice day!
