restricted values that can be entered

M

mweber

When entering information into a cell, excel comes up with a error messages
that states " The value you entered is not valid. A user has restricted
values that can be entered into this cell". The cell is formatted as General
and is not protected.
 
V

vezerid

Select the cell and issue Data | Validation. You will see that someone
has entered rules restricting permissible values. From the three tabs
in the dialogue box you should find out what the rule is.

HTH
Kostis Vezerides
 
C

confused

click on data then validation and see what restrictions are in place..

a intresting floor with excell is that even with data validation on it does
not stop you typing data into another place and pasting it into the protected
cell
 
Top