Skip to Content
Former Member
Jun 01, 2006 at 11:53 AM

queries inserted in workbook


Hello Gurus,

I have 6 queries inserted in a workbook. each queries have same or different variable selections. when I refresh the query each time the variable screen pops up and the user has to manually enter the variable.

My question is, can we create a single variable entry screen for all the variables in each query and when we refresh the workbook only a single variable entry screen takes all the variables and refresh it. Kindly respond if someone came across such a situation.