Share via


PivotTable.PreserveFormatting Property

This property is True if formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property PreserveFormatting As Boolean
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As Boolean

value = instance.PreserveFormatting

instance.PreserveFormatting = value
bool PreserveFormatting { get; set; }

Property Value

Type: System.Boolean

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace