Control order of single refresh of multiple query workbook
I have a workbook which contains 3 queries. The selections variables are as follows:
- Query 1: Date, unit of measure
- Query 2: Date
- Query 3: Date, unit of measure, currency
The number of selection screens which I have to execute depends in which order the browser executes the queries. If it selects query 1 first, the selection screen for query 2 wont appear (as the range of dates is taken from query 1 selection screen). The selection screen for query 3 appears but with only the field currency (the dates and unit of measure are taken from query 1 selection screen).
Is it possible to control the order in which the browser executes the queries when I do a refresh all? i.e. if query 3 is executed first I will only have to execute one selection screen, the values for the other two will be taken automatically.