How do i get Data Validation to accept another workbook?

[Natalya]

Hello

Ok I followed the instructions on the Help to create a dop down using a list
of entries located in another workbook, but when I get to Step 6 that says to
enter the name of the workbook with an equal sign, I get an error that reads:

You may not use references to other worksheets or workbooks for Data
Validation criteria.

Any insight into this problem would be appreciated.

thanks!

 

[excelent]

Try create a defined name of ur range, then use this name in DV

"Natalya" skrev:

 

[Debra Dalgleish]

There are instructions here that might help you:

http://www.contextures.com/xlDataVal05.html