Optimising my current PQ model

[jimrward]

I am still on the learning curve so any advice is welcome
I have a raw data set of 120k rows of data, from which I have nearly 20 routines constructed which work fine

on the right hand side I can see my modules with the initial master at the top, with all others using this for a reference, there are no dependencies in the child modules for want of a better term

when I refresh the queries they all seem to whirl around simultaneously is there a set order of precedence that these are evaluated ?

I want to move the positions of some of them in the list so I can reference them easier and have similar modules together

do i need to look out for anything or let PQ handle everything so as not to cause a bottleneck

 

[johnny51981]

With the Refresh All function, PQ will always determine the order in which queries are refreshed. You can set up VBA to refresh in a specific order.