Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |