How To Troubleshoot Excel This Value Doesn’t Match the Data Validation Error?

Sometimes the customer faces the issue like this value doesn’t match the data validation error. In order to fix this issue, user should read this blog. For help or details, the user should go to www.office.com/setup.

Method To Troubleshoot Excel This Validation Doesn’t Match the Data Validation Error:

1: Remove Data Validation:

First, you should select the cell in which you are getting data validation error. After this, you should visit to the Data tab and then tap on the “data validation” icon from “data tools” group. Now in the opened data validation window, you should switch to the Settings tab. Then, you should click on the Validation criteria section. If you want to disable the data validations, then you should choose the Any value option from the drop-down which is present in Allow section. At the end, you should hit on the OK button.

2: Input Message:

You should choose the cell in which the user is getting data validation error. Now, you should visit to the Data tab and then hit on the “data validation” icon from the “data tools” group. Then in the opened data validation window, you should switch to the Input Message tab. At this point, you should put a check across the ‘Show input message when the cell is selected’ option. At the end, you should enter a title and then input message.

3: Data Validation Error Messages:

If the user faces error messages, then you should press any of the buttons of Retry, Cancel & Help.

Help

When you press on Help, then this will take you to the data validation page. Then in the window, you will read the instructions related to setting up the data validation cells. Here, you will not get any details why the entered is invalid.

Cancel

When you press the cancel button, then it will clean up the cell so that you can enter a new value or the user can select from the drop-down list.

Retry

The value, you typed in the cell gets highlighted so the user can type a new value. If the user, wants to use the drop-down arrow, then you should clear the cell. office.com/myaccount

4: Turn Off Error Messages:

For this, you should choose the cell in which the user is getting data validation error. After this, you should go to the Data tab and then tap on the “data validation” icon from “data tools” group. Now in the opened data validation window, you should switch to Error Alert tab. At last, you should remove the checkmark from “Show error alert after invalid data is entered”

5. Turn Off Table Data Setting:

If the user wants to close all the data validation warnings in the table. For this, you should change the excel options. Now, you should click on the arrow which is present on the error alert and then tap on the error checking option. After this in the options window, you should go to the formula category and then just scroll down to the Error Checking Rules section. Here, you should un-check the checkmark for “Data entered in a table is invalid”. At the end, tap on OK option.

Through this process, the user can fix the excel validation doesn’t mean the  validation error. If the customer need help, visit to office.com/setup

Hit on this link: How To Troubleshot If Microsoft Store is Blocked?

Leave a Reply

Your email address will not be published. Required fields are marked *