Data validation error alert

When you try to enter or change data in a worksheet cell, you see a data validation error alert. This alert signifies that the owner of the workbook applied data validation to the cell to prevent users from entering invalid data, and implemented the error alert to let you know that the data you entered is invalid.

You can enter only valid data in cells that have data validation applied. If you are not clear about the validity of the data that you can enter, you should contact the owner of the workbook.

If you inherited the workbook, you can modify or remove the data validation unless the worksheet is protected with a password that you do not know. If possible, you can contact the previous owner to help you unprotect the worksheet. You can also copy the data to another worksheet, and then remove the data validation. For more information about how to change or remove data validation, see Change data validation settings or Remove data validation.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!