Excel Services Options
Use these options to define what parts of the workbook are shown in the browser and to define parameters.In this article
ShowShow
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 Sheetscheck 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.
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 Rangecommand (Formulastab,Named Cellsgroup,Name a Rangebutton). 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.