View My Drafts
Hello,I am hoping someone can help me figure out when a Quick Query is ran and the selection of connection is picked in order for the Excel file to be refreshed how does the end user update the filters they have set at the Quick Query level (ie.. Period to post, or date fields) when refreshing the connected Excel file? I found where the command text under the connection properties is, but this is not a feasible solution that the end users can use. They are not systems people and do not understand SQL statements.I appreciate any suggestions the group may have.Thank you,Melanie
As you can see, you can set the parameter to reference a cell in the worksheet, allowing the user to easily change the parameter directly in the worksheet. With "Refresh Automatically..." checked, whenever they change the value of that cell, the query will refresh.
Hope this helps.