JWGoldfinch
Board Regular
- Joined
- Dec 23, 2009
- Messages
- 50
I have a workbook with multiple MS-Queries built into it. These are ODBC access to data on an IBM iSeries 400. I need to know if there is a way to have the queries process in a given order. Example Query 1 is dependent on the results of query 2. Currently when I press "Refresh All" it runs the in order 1 then 2, I then have to refresh query 1 separately again to gain the desired results. This would not be bad if the workbook only had 2 queries, but I have workbooks with as much as 8 queries (Or More) and if there were 8 I might need them processed (4,1,2,5,3,7,6,8) when query 4 depends on results from query 8, Etc. Is there a way to give Excel an order of processing? Any Assistance would be greatly Appreciated.