Hi,

I'm not clear on what exactly your problem is. If you are trying to use a
range from another workbook in a data validation list, try this:


Here is an example of applying data validation between workbooks:

1. In the one workbook name the range containing the items you want listed,
here I named it Months. (highlight the range and choose Insert, Name,
Define, type Months into the Names in workbook box and click OK).
2. Move to the workbook where you want to display the list and choose
Insert, Name, Define and in the Names in workbook box enter List. In the
Refers to enter something of the form
='10-21-2008.xls'!Months
3. Select the range where you want the list and choose Data, Validation, List
4. In the Source box enter =List
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jessica" wrote:

Hi, I posted this over in Excel Links but I don't think it gets much traffic.

I have book1 that has a query that brings down a list from access (name=
Project). I need to use this list in a drop down box (validation). I also
need to update the list periodically.

The problem is that my users are opening the spreadsheet as a template and
may need updates while using it. They do not have Access so they can't do
the update.

So, I wanted to create book1 with the list & query. Then have the template
(book2) reference the list in book1.

I tried:
1) doing a copy/paste/named range macro but that just seems like a workaround
2) creating a named range in book2 that references book1 but it only works
when book1 is open.

Any suggestions?