Export Wizard dialog: Parameter Prompts page

Use this dialog to specify the parameter values you want Microsoft Excel end users to specify when they open current worksheet exported to Web Query (*.IQY) format. For example, if you export a worksheet with a Year parameter, you might want Microsoft Excel end users to specify the year they want to analyze. If you do not prompt Microsoft Excel end users for parameter values, they always see data for the current parameter values displayed in the worksheet.

Note: This dialog is displayed if you select Web Query for Microsoft Excel 2000+ (*.iqy) as the export type and select the Parameter Values check box on the "Export Wizard dialog: Format and Name page".

For more information, see:

"About exporting worksheets to Microsoft Excel Web Query format"

Parameters

Use this list to specify the parameters you want Microsoft Excel end users to specify a value for when they open Web Query file.

• Select

  Use check boxes in this column to select and deselect parameters. Select the check box to prompt Microsoft Excel end user for a value for that parameter. Clear the check box to always see data for the current parameter displayed in the worksheet.

• Parameter

  This column shows the name of the parameters in the current worksheet.

• Type

  This column shows whether the parameter is indexed.

  If the parameter is indexed, the drop down list enables you to specify whether the Excel end user is prompted to enter a value (that is, select Value from the drop down list) or index value (that is, select Index from the drop down list) for the parameter. For example, for a Month item, you might want the Excel end user to specify the value January or the index value 1. For more information about using indexed parameters, see "About using indexes and values in parameters".

  If the parameter is not indexed, this column is read only and displays 'Value'.

• Current Value(s)

  This column shows the current value of the parameter. If the Microsoft Excel end user does not specify a different parameter value when prompted, this parameter value is applied to the worksheet values.

• Worksheet Name

  This column shows the name of the worksheet that contains the parameter.

  Note: This column is only displayed if you export an entire workbook.

Select All

Use this button to select all parameters in the list.

Select None

Use this button to deselect all parameters in the list.