I have a complex PQ set of queries that eventually return a set of data, which is used in pivottables.
I wrote a macro (triggered by a button) that:
a. Refreshes the PQ connections
b. Refreshes the Pivottables.
I read that I need to disable the background refreshing of the PQ connections, which I did.
Yet, when I use a large amount of data source, it doesn't work well.
I obtain a weird set of pivot tables. It looks like the pivottables were engaged while the data wasn't ready yet.
When I then rightclick on the pivottable and hit Refresh (or re-engage the macro), then it is OK.
I've seen some references to this, and some advises (like 'DoEvents'), but it doesn't seem to work ...
Thanks for any assistance.
I wrote a macro (triggered by a button) that:
a. Refreshes the PQ connections
b. Refreshes the Pivottables.
I read that I need to disable the background refreshing of the PQ connections, which I did.
Yet, when I use a large amount of data source, it doesn't work well.
I obtain a weird set of pivot tables. It looks like the pivottables were engaged while the data wasn't ready yet.
When I then rightclick on the pivottable and hit Refresh (or re-engage the macro), then it is OK.
I've seen some references to this, and some advises (like 'DoEvents'), but it doesn't seem to work ...
Thanks for any assistance.