QueryTable objects have a boolean "Refreshing" property that returns the status if the query is setup as a background query. You could also (I believe) just turn off the Background query option on all queries, or perhaps just the last query

-Bra

----- David wrote: ----

I have an Excel worksheet which is opened from a Access
2002 project vba module. The worksheet has several
MSQUERY queries which are triggered by the Access project
writing to particular cells. After writing to the Excel
cells the Access application tries to 'save as' the
worksheet. Unfortanetly Access is requesting the 'save
as' whilst the data refreshes are ongoing.

My question: is there a way of interrogating Excel to find
out if a data refresh is outstanding

Thanks in advance

David.