---

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 will 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.

• 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.