value you entered is not valid

[excel_student]

Hello
I am working on this legacy excel sheet and i tried to put a value in this worksheet and got the error

"Microsoft Excel


The value you enetered is not valid

A user has restricted values that can be entered into this cell"


how can i change these values?

[Domenic]

Try the following...

1) Select the cell in question

2) Data > Validation

3) Make the necessary change or click on 'Clear' to remove the Data Validation

4) Click OK

Hope this helps!

[excel_student]

Thanks dude
i did the data followed by validation option

but the validation option in the data dropdown list is greyed out

what do i do?

[Domenic]

Do you have your worksheet protected? If so, unprotect it.

Do you have more than one worksheet selected? Look in the title bar for [Group]. If you see it, right-click on any worksheet tab in the grouped sheets and select Ungroup Sheets.

Also, you can't change the validation if the workbook is shared.

Hope this helps!