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
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