Skip to Content
0
Former Member
Jun 09, 2009 at 06:04 AM

Use of Variable - Refreshing the Queries in Workbook

23 Views

Hi All,

I have a workbook which contains 5 Queries. All these queries uses the same variable. While I am refreshing all the queries in the workbook, it pops-up the variable input screen 5 times.

Here I just want the variable screen appear to be once and the same input be taken to all the queries.

We are in 3.x.

In 7.x Analyzer, I know that When you have multiple queries(with variables) embedded in a single workbook, we can use "Change Variables" icon to acheive the same.

How can I achieve this in 3.5.

Thanks in advance.

Siva

Edited by: Siva Reddy S on Jun 9, 2009 10:32 AM