IPivotTableOptions Properties

Specifies the string to be displayed in column header of pivot Table when in compact layout mode.

Specifies the position for the field representing multiple data field in the PivotTable, whether that field is located in the row area or column area. value start with 0 , -1 means the last position

True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.

Gets/sets value controlling whether or not filter buttons and PivotField captions for rows and columns are displayed in the grid.

True if the PivotTable report displays a custom string in cells that contain null values. The default value is True.

True if the PivotTable Field dialog box is available when the user double-clicks the PivotTable field

Returns or sets the string displayed in cells that contain errors when the DisplayErrorString property is True.

Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.

Indicates whether the PivotTable has an autoformat applied. Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007

True to disable the alert for when the user overwrites values in the data area of the PivotTable. True also allows the user to change data values that previously could not be changed

True if data for the PivotTable report is saved with the workbook. False if only the report definition is saved

True if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.

Returns or sets the string displayed in cells that contain null values when the DisplayNullString property is True.

Returns or sets the order in which page fields are added to the PivotTable report’s layout

Returns or sets the number of page fields in each column or row in the PivotTable report.

True if formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items.

True if the print titles for the worksheet are set based on the PivotTable report. False if the print titles for the worksheet are used.

Repeat All Item Labels or Do Not Repeat All Item Labels.

This property specifies layout settings of the pivot table

Specifies the string to be displayed in Row header of pivot table when in compact layout mode

This property specifies the pivot table row layout settings.

True if an asterisk (*) is displayed next to each subtotal and grand total value in the specified PivotTable report

Specifies a boolean value that indicates whether the "custom lists" option is offered when sorting this PivotTable

The ShowDrillIndicators property is used for toggling the display of drill indicators in the PivotTable.

False to disable the ability to display the field list for the PivotTable. If the field list was already being displayed it disappears.

Specifies a boolean value that indicates whether the in-grid drop zones should be displayed at runtime, and whether classic layout is applied.

True, if tooltips displayed for the pivot table cell.