If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data/Validate/List
I am attempting to use a drop down list which is located in a separate
workbook. I've gone through the directions several times by using the help menu "Create a drop-down list from a range of cells" When I get to the last step which is entering the source, I get a pop up message which says "You may not use references to other worksheets or workbooks for Data Validation criteria" This is confusing because it specifically shows how to use separate notebooks. Help anyone! -- Thanks for responding to my request |
#2
|
|||
|
|||
Data/Validate/List
You would have to use a defined name for the source *and* the source
workbook *must* be open for it to work. What this boils down to is it may not be worth the trouble and you'd be better off just putting the source in the workbook where it's needed. See this: http://contextures.com/xlDataVal05.html -- Biff Microsoft Excel MVP "BobxxCalgary" wrote in message ... I am attempting to use a drop down list which is located in a separate workbook. I've gone through the directions several times by using the help menu "Create a drop-down list from a range of cells" When I get to the last step which is entering the source, I get a pop up message which says "You may not use references to other worksheets or workbooks for Data Validation criteria" This is confusing because it specifically shows how to use separate notebooks. Help anyone! -- Thanks for responding to my request |
Thread Tools | |
Display Modes | |
|
|