Ok, I'll try my best to explain here.

The user opens the .xlt file on Monday. a new project is added to the list
on wed. The user has already saved their weekly file as an xls on their hard
drive. I can't do a transfer spreadsheet to their individually saved files.
They only open a new template on Mondays.

I wanted them to have an update button that would allow a refresh sourced
from a central excel file that I can update mid-week.

"JCS" wrote:

Hi Jessica

Yes I understand that your users do not have Access, however, the
TransferSpreadsheet function in a macro can be run by you or whoever has
access to the db to produce the query results in a spreadsheet that can then
be used by your users vis-a-vis a query in that spreadsheet. Confusing isn't
it? This is the way I would do it.

John

"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?