Use these options to define what parts of the workbook are shown in the browser and to define parameters.

• Show

• Parameters

Show

Show combo box   Enables you to select the parts of the workbook that you want to show in the browser and Microsoft Office Excel Web Access. Select one of the following:

• Entire workbook   Shows all worksheets and data. It is selected by default.
• Sheets   Presents a list of worksheets that are included in the workbook. All sheets are selected and shown by default. Clear the check boxes of the worksheets that you don't want to show. To quickly select all sheets again, select the All Sheets check box.
• Items in the Workbook   Presents a list of items (such as named ranges, charts, tables, or PivotTable) that you can show. By default, the items are not selected and therefore not shown. Select the check boxes for the items that you want to show.

 Top of Page

Parameters

Parameter list   Displays the parameters that are defined in the workbook and provides the following details:

• Name   Displays the names of the defined parameters, sorted by default in ascending order.
• Comments   Displays the comments that are associated with the parameter names.
• Value   Returns the current value of the cells that the name of the parameter currently refers to and displays error codes, character strings, numbers, or data ranges.
• Refers to  Shows the cell address that the parameter currently refers to.

   Note   The names of parameters refer to a single cell that you have named in the worksheet by using the Name a Range command (Formulas tab, Named Cells group, Name a Range button). Parameters cannot be set for named ranges that contain more than one cell.

Add   Click to add new parameters in the Add Parameter dialog box. Places new parameters at the bottom of the list and then sorts the list in the current sort order.

Delete   Click to delete selected parameters. This button is unavailable if the Parameter list is empty.

Delete All   Click to delete all parameters that are listed in the Parameter list.

 Top of Page