Well, not really. The sequencing's OK, so no circularity.
Another thing I've discovered is even if I try to do a data table using
VBA, I still run into the same problem. There's no awareness that a
query needs to finish before proceeding through the
VB. This again
despite unchecking the background refresh property for the data area.
gocush wrote:
Excel
model determines parameters to feed the query, whose results further
feed subsequent steps in the Excel model.
*******************
This sound like you may be approaching a circular loop. If this is
all in
one step, the code may be divided into steps with separate command
buttons so
that excel will "wait" for the results of the query before moving on
to the
last step.
" wrote:
Thanks.
Wrong on 1, right on 2. No updates of data based on Excel data.
Excel
model determines parameters to feed the query, whose results
further
feed subsequent steps in the Excel model.
The real issue at hand is (apparently) data tables calculated w/o
first
waiting for dependent query to generate new results that feed the
model. I've noticed some discussion of a similar issue w/ pivot
tables, as well as 1 MS KB article which doesn't quite describe my
issue but related: http://support.microsoft.com/kb/236990.