Sunday, March 16, 2014

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

This is the error you will receive if any cell is have Data Validation is activated. To fix this issue do 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