Export Wizard dialog: Page Item Prompts page

Use this dialog to specify the page item values you want Microsoft Excel end users to specify when they open the current worksheet exported to Web Query (*.IQY) format. For example, if you export a worksheet with a Year page item, 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 page item values, they always see data for the current page items 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 Page Item 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"

Page Items

Use this list to specify the page items 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 page items. Select the check box to prompt Microsoft Excel end user for a value for that page item. Clear the check box to always see data for the current page item displayed in the worksheet.

  • Page Item

    This column shows the name of the page items in the current worksheet.

  • Worksheet Name

    This column shows the name of the worksheet that contains the page item.

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

Select All

Use this button to select all page items in the list.

Select None

Use this button to deselect all page items in the list.