Formatting is not retained in PivotTable in Excel When you pivot fields or update data in a PivotTable, the formatting is cleared. This problem occurs if you update data or change the layout of the table when the following conditions are true: You click PivotTable on the PivotTable toolbar, point...