Refresh order for multiple queries in a Workbook

Question: I have three queries embeded in a workbook, in three worksheets:
WS 1 : Q1
WS 2 : Q2
WS 2 : Q3

When I refresh workbook for all queries, the system starts by Q3, and I want it to start by Q1 so I can use its Variants.

Do anybody know if is it possible to set this refreshing order?

Thanks a lot for your help!!

Answer:
try changing the queries in reverse order as you wish to have them executed... then save your workbook again

I believe that was the trick...

cheers,

El Belgio

Answer:


Answer:



_________________
Keep smiling
Copyright ?2007 - 2008 www.jt77.com