How do i get Data Validation to accept another workbook?
 

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!

How do i get Data Validation to accept another workbook?
 

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

"Natalya" skrev:

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!

How do i get Data Validation to accept another workbook?
 

There are instructions here that might help you:

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

Natalya wrote:
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!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com