"The value you entered is not valid. A user has restricted values that can be entered into this cell.".

Question

I got the error: "The value you entered is not valid. A user has restricted values that can be entered into this cell.".

Any ideas? I'm new here.

Answer 1

Hi @BT

Does this issue occurs with all Excel workbooks?

Generally, this error caused by data validation in the sheet for specific data values only.

Please select the cell or cells where this happens > Go to Data tab > Click Data Validation (In the Data Tools group) > Check whether there is a validation rule set?

If you want to remove the validation rule, please tick the box of 'Apply these changes to all other cells with the same settings', click 'Clear All'.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---