View Single Post
  #1   Report Post  
Deb
 
Posts: n/a
Default Linked query not expanding with new data

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.