Skip to Content
0
Former Member
Sep 14, 2005 at 10:10 PM

Refresh workbook with same selection criteria

28 Views

Hello experts,

I have a workbook with 6 queries in 6 tabs but with the same variable selection criteria example fiscal year and posting period, now when I input different selection criteria in the first popup, can't I see the specified results in the next 5 queries. Do I need to refresh each individual query and input the selection.

Please let me know where exactly I need to change this property.

Thanks in advance,

Nikki

Guys this seemed to be a simple question, but I have a doubt if its complicated or my explanation wasn't clear??

Need to refresh my workbook giving an input in the first query which refreshes all the remaining queries in the same workbook with the same selection criteria in all the queries.