Select any cell in your pivot table and right-click. Then choose PivotTable Options from the context menu. In the PivotTable Options dialog box, click the Layout & Format tab. Then check Preserve cell formatting on update item under the Format section or you cant get tips on
O365CloudExperts.
Regards,
Jerry