Skip to Content
Former Member
Jul 25, 2005 at 07:10 PM

Multiple Queries in a Workbook - Variables on same screen



I have 2 queries embedded in 2 sheets of a workbook. Except one all the other variables are common to both the queries.

The issue is, whenever i refresh the workbook, the variable screen is popping up twice. First time with all the variables of first query and the second time with only the different variable of the second query.

How can i make the variable screen to show only once with all the variable from both the queries.