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.