Home |
Search |
Today's Posts |
#1
|
|||
|
|||
link from one workbook to another workbook using a dropdown?
Is it possible to link from one workbook to another workbook using a
dropdown? I have source.xls Defined Name: Numbers refers to: =Sheet1!$A$1:$A$30 when I try to set up my Data Validation for my dropdown in my destination.xls I get the follwoing error "You may not use references to other worksheets or workbooks for Data Validation criteria" Am I trying to do the impossible? Any help is much appreciated |
#2
|
|||
|
|||
Check out http://www.contextures.com/xlDataVal05.html by Debra Dahlgliesh.
"sunflower" wrote: Is it possible to link from one workbook to another workbook using a dropdown? I have source.xls Defined Name: Numbers refers to: =Sheet1!$A$1:$A$30 when I try to set up my Data Validation for my dropdown in my destination.xls I get the follwoing error "You may not use references to other worksheets or workbooks for Data Validation criteria" Am I trying to do the impossible? Any help is much appreciated |
#3
|
|||
|
|||
Hi!
This won't work the way you'd like.....but You'd have to recreate the range name in the Destination.xls and even then it will only work if Source.xls is open. In Destination.xls InsertNameDefine Numbers Refers to: ='[source.xls]sheet1'!$A$1:$A$30 Then Data Validation Allow: list Source: =Numbers As long as Source.xls is open it will work. If Source.xls is not open it will not work. Biff "sunflower" wrote in message ... Is it possible to link from one workbook to another workbook using a dropdown? I have source.xls Defined Name: Numbers refers to: =Sheet1!$A$1:$A$30 when I try to set up my Data Validation for my dropdown in my destination.xls I get the follwoing error "You may not use references to other worksheets or workbooks for Data Validation criteria" Am I trying to do the impossible? Any help is much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Removing link to another workbook | Excel Discussion (Misc queries) | |||
Cells to link to "current workbook" | Excel Discussion (Misc queries) | |||
How do I link data from another workbook using a different file na | Excel Discussion (Misc queries) | |||
Link to password protected workbook | Excel Discussion (Misc queries) |