on 07-18-2007 10:55 PM
Hi,
I have 3 queries in a workbook with the same variables. How can I refresh all the 3 queries when I change the variable value. It allows me to refresh only one query at a time but I need to refresh all the 3 queries at once whenever variable value changes.
Thanks,
Kal
Hi,
Open the workbook goto>query properties>interaction-->check refresh query when opening workbook and click on "OK for all queries" push button in the same pop up.
Now after excecuting the workbook select any non result area and click on refresh it will ask for "No query is selected Do you want to refresh all queries in the workbook" and click yes.
This will solve your problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi..
In 7.0, All variables in the workbook are shown in the variable screen, you can't get variable screen for each query.
In 3.5 we were able to get like that.
from SP-13
Refresh individual queries within a workbook (Single DataProviderRefresh)
hope it will help...
all the best...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Incase of Web Template system consolidates selection parameters / variables of all query in to single input web page .
I think it is not possible that system ( ie. same variable across 3 queries) will prompt for dialog only one time instead of 3 times.
Hope that helps.
Regards
Mr Kapadia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.