Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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......
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referring to external workbook in Data Validation 2
dependent lists on data validation 3
Data Validation for list in a different workbook 2
Excel Highlighting duplicates 0
create drop down list from different workbook 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
problem with drop down lists 1
How do i get Data Validation to accept another workbook? 2

Back
Top