TableStyle.ShowAsAvailablePivotTableStyle Property (Excel)

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

Version Information

Version Added: Excel 2007


expression .ShowAsAvailablePivotTableStyle

expression A variable that represents a TableStyle object.


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


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.

See Also


TableStyle Object

TableStyle Object Members