restricted values that can be entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restricting Cell entry to certain letters 7
custom data validation on cells with data validation values 2
Data Validation With Date Range 1
Locked Cells 1
How do I make Excel drop-down list values editable? 1
How to use formula to decide when to apply TIME data validation 3
resettable, over-ridable, default cell values 0
Data Validation - Complex Q 2

Back
Top