Validations from another book

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

In data/validation the source is =() but to access the source via another
book is it simply a matter of giving the full path name?
 
Hello gentlemen,

Thank you for the link.
I have followed the example but I cannot seem to get it to work.

Here is an example of what I have done
Book1 contains the range called List

Book2 is where I want to use it in a validation list.
First I created a defined name (in Book2) called Book2List with the range
name
=Book1.xls!List
Then in Data/Validation the source is =Book2List

I am obviously overlooking something but I cannot put my finger on it.

Regards
Pat
 
I think you're going to have to follow those instructions one more time or post
back what you did and where it failed.

And just maybe, you skimmed over this line:

You can create a dynamic range that refers to a dynamic range in another (open)
workbook.
 
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

Creating a list from another sheet or workbook 6
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation list 1
How to create absolue path link to another workbook (Excel 2003) 1
Data Validation List with blanks 1
Offset Named range in Datavalidation List 4
[err] Excel 2007 - Data validation from another sheet? 1
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2

Back
Top