I don't know, but it shouldn't take too much testing to find out.

Please post back your results when you get them.

Buck wrote:

Dave, how does 'activeworkbook.refreshall' sequence the refresh tasks?
More specifically, will it refresh query-tables before it refreshes the
pivot-tables based on those query tables?

--

Dave Peterson