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!

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!

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