on 11-20-2008 7:28 AM
Hi,
Generally when we open the workbook, query runs automatically with the last accessed selections or it pops up the variable screen and runs the query. Is there any way like query can be shown as a button, and runs when the user clicks on the button? It is just like planning folder wherein we have multiple layouts shown as buttons. If two queries are inserted in the workbook, on workbook open, it runs both the queries, means it is locking both the queries data even though user will plan on one query at first and the second query next. Please let me know if any one has done that.
Thanks,
Bindu
In the workbook settings, there is an option 'refresh workbook on open'. Uncheck that.
To create a button to re-run the query, use the command which sets a query to a data provider - put that behind the button.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bindu,
an easy solution could be run query in non-planning mode (you have a tick in query definition) and then add a button to change query to planning mode in the workbbok (there are standard function available in workbooks) This button can be for only one query or multiple queries in workbook.
Regards,
Enrique
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.