I have query tables in a worksheet that I wish to get refreshed each time a
macro is executed. The query tables are set to refresh data from SQL
database every minute (via Data...Connections...properties). However, when
the macro is executed, there is an error whenever the background refresh
process is taking place. Is there some way of getting around this eg.
knowing whether the background refresh process is taking place and starting
the refresh process after?
Is there a better refresh macro that will only refresh the query table and
not the entire worksheet?
Macro:
sub Rfresh()
ActiveWorkBook.RefreshAll
end sub