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.