NoPreserveFormatting Element (Microsoft Excel)

Specifies whether formatting is preserved when data is refreshed.

Contained In

PivotTable, QueryTable

Remarks

If <x:NoPreserveFormatting/> is specified, formatting is not preserved.

Examples

See the examples in the PivotTable and QueryTable element topics.