Edit Parameter Values dialog

Use this dialog to enter dynamic input values for active workbook or worksheet parameters. You do this by specifying parameter values, which are typically used to:

• provide input to conditions that are used to filter worksheets - for example, when prompted to choose a month, you might enter 'January' to look at data for January only

• provide input to calculations - for example, when prompted to choose a rolling average value, you might enter '3' to calculate a three month rolling average

For more information, see:

"What are parameters?"

"About using parameters"

Please select values for the following parameters:

<Parameter list>

This area contains one or more fields into which you enter parameter values. Each field has a prompt (typically an instruction or question) telling you what value to enter. For example, if the prompt is 'Please choose a month', enter 'January' to specify a month to analyze.

Use the down arrow next to each item to select from a list of valid values.

If the list of values in the drop down list is too long to display on screen, the "Select Value dialog" or "Select Values dialog" is displayed. These dialogs enable you to search for and select the values that you want to use. For more information, see "Using lists of values (LOVs)".

Note: When you have filtered the data, you can change the parameter value at any time by choosing Sheet | Edit Parameter Value.