Data Validation

P

Prakash

I am trying to do a drop down menu on a workbook, getting the data from another workbook. I did define name on both workbook. When I try to Data Validation this message is showing up "You may not use references to other worksheets or workbooks for Data Validation criteria". What should I do?

Thn
Prakash......
 
J

Jason Morin

Press Ctrl+F3 and change the named range to include the
name of the source workbook. For example:

=[Book13.xls]Sheet1!$A$1:$A$6

and call it "mylist". Now use =mylist in Validation.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to do a drop down menu on a workbook,
Click to expand...
getting the data from another workbook. I did define name
on both workbook. When I try to Data Validation this
message is showing up "You may not use references to
other worksheets or workbooks for Data Validation
criteria". What should I do?
 
Top