Hi All,
My excel worksheet loads data from access when the sheet opens. My data can be refreshed if I set the refresh period. However, if I add a new record from Access during runtime, the new record can not be refreshed from the data sheet. Do you guys have clue ? I wrote the following...