Parameters in Excel

Parameters are used in Excel, in conjunction with query formulas, to provide criteria for the query being executed.

Use Parameters in Excel

1. Prior to using a new or modified query, in Excel, from the Spreadsheet Server Ribbon, select Refresh, or, Refresh > Queries. The system refreshes the query data.
2. Create the Excel sheet, and assign cell references for each parameter.

3. Select the cell where the query formula is to reside, then, from the Spreadsheet Server Ribbon, select Formula Builder.  The Formula Builder panel appears.
4. Select the appropriate formula from the Formula section, and assign values to the arguments, including the cell positions of the parameters.

5. Click the Insert button to save the formula to the cell.
6. To change the query criteria value, enter the new value in the designated cell, and rerun the query.