Linked query not expanding with new data

[Deb]

Using Excel 2000. I have an worksheet which is linked to an Access crosstab
query. Every time the data is updated, the excel file doesn't automatically
update the additional lines of data.

Example, initial link to data was through October. November information
added to table in Access but it doesn't display on the Excel file.
Therefore, I am finding myself clearing the link and re-linking each time the
initial data is updated.

There has to be an easier way! Thanks in advance for your help!
--
All help greatly appreciated.

[spoolly]

Hi.

Right click when over a data cell and go to data range properties.

Check the box with: "Overwrite existing cells with new data, delete unused cells".

You can also check the box with "Autofill formulas in next columns" (this is usefull if you want to put some formulas).

Hope this helps you.

Best regards.

Spoolly