The Sheet Settings page is used to set up the general settings of the PivotTable Sheet.
Fields
Sheet Name
Specifies a name for the sheet. If no name is specified, the type of the sheet is used. It is additionally possible to specify the placeholder %1 in the text, which is replaced by the type of the sheet.
Layout, Fields
Classic PivotTable Layout
Specifies whether the PivotTable should be created in Classic Layout by default. The Classic Layout enables dragging of fields in the grid.
The default setting for the field can be set in the Excel Evaluation Setup.
Grand Totals
Specifies whether to display the grand totals next to the last column resp. at the bottom of the PivotTable.
The grand total for rows is displayed next to the last column:
The grand total for columns is displayed at the bottom of the PivotTable:
Style, Fields
PivotTable Style
Specifies a style for the PivotTable. If the field is empty, the default setting from the Excel Evaluation Setup will be used.
Row Headers
Specifies whether to display special formatting for the first row of the PivotTable.
Column Headers
Specifies whether to display special formatting for the first column of the PivotTable.
Banded Rows
Specifies whether to display banded rows, in which even columns are formatted differently from odd rows.
Banded Columns
Specifies whether to display banded columns, in which even columns are formatted differently from odd columns.
Chart, Fields
Chart
Specifies whether a chart should be created for the PivotTable. The chart will be created in a separate sheet.
Chart Sheet Name
Specifies a name for the chart sheet. If no name is specified, the type of the sheet is used. It is additionally possible to specify the placeholder %1 in the text, which is replaced by the type of the sheet.
Chart Title
Specifies a title for the chart. A title will only be added to the chart if the field contains a value.
Chart Type
Specifies the chart type.
Print, Fields
Orientation
Specifies the default print format for the worksheet.
Fit width to pages
Specifies whether the size of the worksheet should be adjusted to fit on the specified number of pages.
Rows to repeat at top
Specifies a range to be printed on each page. For example, you can specify '$1:$1' for the first row of the worksheet.
Columns to repeat at left
Specifies a range to be printed on each page. For example, you can specify '$A:$B' for the first two columns of the worksheet.
Page Order
Specifies the sequence in which the worksheet data is numbered and printed if it does not fit on one page.
Sheet Settings
The grand total for columns is displayed at the bottom of the PivotTable:
