Updating a dropdown list from SQL server

I have a worksheet with a drop down of active projects in one of its columns.
The data on what projects are active comes from a SQL server database. To
start the process I defined a range that includes all the imported project
data, created the drop down and copied it to the appropriate number of rows
in the Projects column.

I have the query dropping the data to an area outside of the normal viewing
area. Over time, the project mix will change, so I need to update the
dropdowns(s). I have no problem refreshing the data from the query, but seem
unable to get the range to resize in the dropdowns following the example in
the online documentation. I intentionally used a named range assuming that
would eliminate the need to go row by row to update the dropdowns.

This leads me to two questions:
1. Are the data in the dropdowns static once populated, or should resizing
the range effect the dropdowns?
2. Am I going about this whole thing correctly?

Thanks in advance for any assistance or insights.

John

Queries automatically create & maintain range names.

if you base your dropdown source on that NAME rather than the address
things should go as planned.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


DevalilaJohn wrote in
<news:<[email protected]>

> I have a worksheet with a drop down of active projects in one of its
> columns. The data on what projects are active comes from a SQL
> server database. To start the process I defined a range that
> includes all the imported project data, created the drop down and
> copied it to the appropriate number of rows in the Projects column.
>
> I have the query dropping the data to an area outside of the normal
> viewing area. Over time, the project mix will change, so I need to
> update the dropdowns(s). I have no problem refreshing the data from
> the query, but seem unable to get the range to resize in the
> dropdowns following the example in the online documentation. I
> intentionally used a named range assuming that would eliminate the
> need to go row by row to update the dropdowns.
>
> This leads me to two questions:
> 1. Are the data in the dropdowns static once populated, or should
> resizing the range effect the dropdowns?
> 2. Am I going about this whole thing correctly?
>
> Thanks in advance for any assistance or insights.
>
> John