Wait for Pivot Refresh before continuing Code Execution

D

Dan

I have a macro that Refreshes multiple pivot tables, then performs various
actions after the pivot tables are supposed to refresh.

However, the code keeps chugging along even before it finishes refreshing my
Pivots. Is there any way to "Pause" until all the refreshes are complete and
then finish executing the rest of the code?

I tried adding a backgroundquery = false to the end, but I guess that only
works for QueryTables and not PivotCaches.

Thanks,
Dan
 

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

Top