Edit Scheduled Workbook dialog: Parameter values tab

Use this dialog to change parameter values required by worksheets. For example, you might enter '2001' when you only want to schedule data for the year 2001.

This dialog is also displayed as:

Copy Scheduled Workbook dialog: Parameter values tab

For more information, see:

"What are scheduled workbooks?"

"About how scheduled workbooks are processed?"

"What are parameters?"

"About using parameters"

Worksheet

Use this drop down list to select the worksheet whose parameters you want to edit. The drop down list contains worksheets being scheduled that have active parameters.

Parameter list

This area contains one or more fields into which you enter a parameter value. Each field has an instruction or question telling you what value to enter. For example, if the prompt is 'Please choose a year', enter '2001' to see data for that year.

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)".