Skip to Content
Former Member
Nov 20, 2008 at 07:28 AM

Query runs automatically on workbook open



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.