Stuck...

M

Mike

How do I link to (and be able to choose data from) a drop list in another
workbook?
Every time I try to type in the path, an error message says its not allowed.
Is there
a way around this problem?
Thanks for any help....
 
P

Peo Sjoblom

1. If you mean data>validation you need to name the list in the other workbook.
2. The other workbook needs to be open, you cannot use a list from a closed
workbook


Regards,

Peo Sjoblom
 
C

CLR

You can link the Validation list in from a closed workbook to a helper list
in this workbook, using formulas like this...

='C:\[Book1.xls]Sheet1'!$D7
='C:\[Book1.xls]Sheet1'!$D8
='C:\[Book1.xls]Sheet1'!$D9.....etc etc

and then set up the Data Validation on the local list.........

hth
Vaya con Dios,
Chuck, CABGx3
 
M

Mike

Thanks for the reply.... I have done both steps but
I still get the error message "You may not use references to other
worksheets or workbooks for data validation criteria".
What have I missed?
Thanks again, Mike.
 
Top