I am importing data on a monthly basis from an access query that varies in
size into an Excel spreadsheet. The named range the data is being imported
into is not adjusting to accommodate the new data, whether it be more data or
less.

For example, if the range of data is A1 to C90 one month, but the next month
the range is A1 to C275, the named range is not adjusting itself to the
furthest portion of the new range (C275).

Is there a setting I'm missing? I assumed the range would adjust according
to the data being imported into it.

Thank you in advance.

The named range adjusts according to the way its Refers To formula is
constructed. Make sure there is some kind of COUNT/COUNTA inside the Refers
To definition. For example:

http://peltiertech.com/Excel/Charts/...umnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

Even easier, establish the data region as an Excel List (Data Menu List).
As data is added or removed, the list automatically resizes, and any
formulas linked to the address of the list automatically adjust to the new
address of the list. Pretty cool feature, my whole reason to upgrade from
Excel 2000 to 2003.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Me" wrote in message
...
I am importing data on a monthly basis from an access query that varies in
size into an Excel spreadsheet. The named range the data is being
imported
into is not adjusting to accommodate the new data, whether it be more data
or
less.

For example, if the range of data is A1 to C90 one month, but the next
month
the range is A1 to C275, the named range is not adjusting itself to the
furthest portion of the new range (C275).

Is there a setting I'm missing? I assumed the range would adjust
according
to the data being imported into it.

Thank you in advance.