Cancelling an OWC Query / Instruction

[Andy Miller]

When using the OWC pivot table control is there anyway you can cancel
an instruction / query once you have instigated it ?. For example you
try and expand too much data for the pivot table to be usable in terms
of speed and wish to cancel the current instruction / query that is
being executed and then refine it to narrow down the selection.

The only way I have found to do this so far is to kill the instance of
IE.

There must be a better way than this as this must be a scenario that
occurs relatively frequently, particularly for new users.

Regards

Andy