View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Natalya Natalya is offline
external usenet poster
 
Posts: 1
Default 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!