View Single Post
  #9   Report Post  
jerry_maguire jerry_maguire is offline
Junior Member
 
Posts: 25
Default Try this:

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