View Single Post
  #9   Report Post  
Old December 31st 20, 08:58 AM
jerry_maguire jerry_maguire is offline
Junior Member
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
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.