Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - but not restricting values
I've applied data validation (list setting) to some cells in my workbook. The
source is a named range in another sheet. When I click on the cells with validation, the dropdown list with the values I expect appears and I can choose them as normal. However, I can also type in any other value I choose and excel will not complain. Anyone know what's causing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - but not restricting values
"Jon5001" wrote:
I've applied data validation (list setting) to some cells in my workbook. The source is a named range in another sheet. When I click on the cells with validation, the dropdown list with the values I expect appears and I can choose them as normal. However, I can also type in any other value I choose and excel will not complain. Anyone know what's causing this? Nothing wrong there. That's the behaviour when you use Allow: List -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - but not restricting values
Go back to one of the validated cells and, from the menu bar, select Data
Validation. Click on the Error Alert tab. What selections have you made there? Unless the first checkbox is selected, there won't be any notification. "Jon5001" wrote: I've applied data validation (list setting) to some cells in my workbook. The source is a named range in another sheet. When I click on the cells with validation, the dropdown list with the values I expect appears and I can choose them as normal. However, I can also type in any other value I choose and excel will not complain. Anyone know what's causing this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - but not restricting values
The strange thing is that the box is selected and the style is Stop.
"bpeltzer" wrote: Go back to one of the validated cells and, from the menu bar, select Data Validation. Click on the Error Alert tab. What selections have you made there? Unless the first checkbox is selected, there won't be any notification. "Jon5001" wrote: I've applied data validation (list setting) to some cells in my workbook. The source is a named range in another sheet. When I click on the cells with validation, the dropdown list with the values I expect appears and I can choose them as normal. However, I can also type in any other value I choose and excel will not complain. Anyone know what's causing this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - but not restricting values
Clarification:
Nothing wrong there. That's the behaviour when you use Allow: List should read as: Nothing wrong there. That's the behaviour when you use Allow: List and the named range covers an empty cell within it Just my observations .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - but not restricting values
Think your defined range covers/carries an empty cell within it.
Remove that empty cell and I believe it'll work -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |