TableStyle.ShowAsAvailablePivotTableStyle Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Sets or returns if a style is shown in the gallery for PivotTable styles or not. Read/write.

public:
 property bool ShowAsAvailablePivotTableStyle { bool get(); void set(bool value); };

public bool ShowAsAvailablePivotTableStyle { get; set; }

Public Property ShowAsAvailablePivotTableStyle As Boolean

Property Value

Boolean

Boolean

Remarks

The property returns True, if the style is shown in the gallery for PivotTable styles.

Note: Users can set the ShowAsAvailableTableStyle or ShowAsAvailablePivotTableStyle properties to False even when the style is already applied to a table or PivotTable. In this case, the gallery will not show the style and no style is shown as selected when the active cell is in the table or the PivotTable.

Applies to