Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop-down list validation won't allow a different worksheet
I'm using Excel 2003 and have setup a list of data and named it. When I try
to setup the drop-down list feature and select data validation and select "List". The list is in a different workbook so I enter the name i have defined preceded with an equal sign. I get an error message 'You may not use references to other worksheets or workbooks for Data Validation criteria'. I had the same drop-down list used with a prior version of Excel. Is there something else I need to do? |
#2
|
|||
|
|||
Different workbook or worksheet?
Worksheet OK, Workbook not. With worksheet, as you say, simply name the list and then put it in the reference box preceded by an = -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "justmetn" wrote in message ... I'm using Excel 2003 and have setup a list of data and named it. When I try to setup the drop-down list feature and select data validation and select "List". The list is in a different workbook so I enter the name i have defined preceded with an equal sign. I get an error message 'You may not use references to other worksheets or workbooks for Data Validation criteria'. I had the same drop-down list used with a prior version of Excel. Is there something else I need to do? |
#3
|
|||
|
|||
Have a look at Debra Dalgleish's site on using a named range from another
workbook and see if you've done all the steps in the right order. http://www.contextures.on.ca/xlDataVal05.html Gord Dibben Excel MVP On Wed, 14 Sep 2005 11:58:09 -0700, "justmetn" wrote: I'm using Excel 2003 and have setup a list of data and named it. When I try to setup the drop-down list feature and select data validation and select "List". The list is in a different workbook so I enter the name i have defined preceded with an equal sign. I get an error message 'You may not use references to other worksheets or workbooks for Data Validation criteria'. I had the same drop-down list used with a prior version of Excel. Is there something else I need to do? |
#4
|
|||
|
|||
Well I'm............
Didn't know you could do that :-( Do now though :-) Thanks Gord (and Debra) Regards Ken.................. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Have a look at Debra Dalgleish's site on using a named range from another workbook and see if you've done all the steps in the right order. http://www.contextures.on.ca/xlDataVal05.html Gord Dibben Excel MVP On Wed, 14 Sep 2005 11:58:09 -0700, "justmetn" wrote: I'm using Excel 2003 and have setup a list of data and named it. When I try to setup the drop-down list feature and select data validation and select "List". The list is in a different workbook so I enter the name i have defined preceded with an equal sign. I get an error message 'You may not use references to other worksheets or workbooks for Data Validation criteria'. I had the same drop-down list used with a prior version of Excel. Is there something else I need to do? |
#5
|
|||
|
|||
Belay that, i stand corrected - see Gord's post.
Regards Ken.............. "Ken Wright" wrote in message ... Different workbook or worksheet? Worksheet OK, Workbook not. With worksheet, as you say, simply name the list and then put it in the reference box preceded by an = -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "justmetn" wrote in message ... I'm using Excel 2003 and have setup a list of data and named it. When I try to setup the drop-down list feature and select data validation and select "List". The list is in a different workbook so I enter the name i have defined preceded with an equal sign. I get an error message 'You may not use references to other worksheets or workbooks for Data Validation criteria'. I had the same drop-down list used with a prior version of Excel. Is there something else I need to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation list with drop down list of options?? | Excel Worksheet Functions | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Using a validation list drop down box with keyboard only | Excel Discussion (Misc queries) | |||
data validation list drop down text format too small | Excel Worksheet Functions |