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 Data Refresh. The system refreshes the query data.
2. Select the cell where the query formula is to reside, then from the Spreadsheet Server ribbon, select Formula Builder. The Formula Builder panel appears.
3. Select the appropriate formula and assign values to the arguments, including the cell positions of the parameters.



4. Click the Insert button to save the formula to the cell.



5. To change the query criteria value, enter the new value in the designated cell and rerun the query.