Pivot table: Cancel long running query?

V

vj

How to cancel a long running query in pivottable.

Each time I drag any dimension to the data axis. The pivottable takes quite
some time. I wonder if there is any event or way by which I can stop the
pivot query process.
In excel a pivot query could be cancelled by pressing <esc> key.

Environment: VB 6.0; WIN 2K; OfficeXP web components; Local cube.

Thanks,
VJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 pivot table subform 0
How to monitor the Pivot Table data. 3
pivot table report 0
Pivot Table macro - strange behaviour 1
Filtering a Pivot Table on the client side 10
Cancel button to quit long running function 2
pivot table queries created in Excel2000 on a NT box in XP? 0
is there such a thing as a fast pivot table? (CAN they byoptimized???) 1

Top