VBA Excel: Trigger a refresh upon data change in sql connection

[Gum]

I would like to trigger a refresh using vba excel to trigger a refresh
whenever the sql data (connected to excel) changes.
Currently I rely on the minimum refresh interval: 1 minute. There are loops
to refresh every 200 milliseconds, but the most efficient has to be whenever
the source data changes. How to get this done?

 

[Gary Brown]

Tie the refresh to the 'Worksheet_Change' procedure of the worksheet.

 

[Gum]

Worksheet_Change as I understand it, is a procedure of the Worksheet Object
whose target address is in the worksheet. That target address on the
worksheet is refreshed (1 minute min time lapse) through a process connected
to the workbookconnection and ODBCconnection. What is required is to get
the ODBCconnection to refresh each time the data in the SQL database changes.