smartsource
Board Regular
- Joined
- Dec 4, 2009
- Messages
- 76
I would like to trigger a refresh using excel VBA to trigger a refresh
whenever sql data (connected to Excel) changes.
Currently I rely on polling with a minimum refresh interval: 1 minute. There are loops to refresh every 200 milliseconds.
I'd like to eliminate the polling and loops and have the source data trigger excel to refresh when data changes. Any Ideas on how to get this done?
whenever sql data (connected to Excel) changes.
Currently I rely on polling with a minimum refresh interval: 1 minute. There are loops to refresh every 200 milliseconds.
I'd like to eliminate the polling and loops and have the source data trigger excel to refresh when data changes. Any Ideas on how to get this done?