Workbook with 3 queries
I have a workbook with 3 query results( 3 reports). Each query has got one variable and all the 3 conatains same variable (CalDay).
When I open the workbook only the variable for the last query is being executed and not the other two.
What I want to know is...since all the three queries contains same variable, is it possible to use single variable screen for all the
three queries in the workbook so that the user will enter the required date once and all the three
queries will be effected.
Please reply me ASAP as this is urgent...
First try to set you curser in a cell outside a query and push the refresh button and answer yes to the question that all queries in the workbook are refreshed.
If this refreshes all you queries then you should do the following
Set the option in the workbook for each query that it should be executed when workbook opens.
Save the workbook.
I hope this helps