Hello Calieth,
loss of formatting after Pivot Table refresh is a known issue and very annoying. The recommended workaround is:
Switch on the macro recorder
Format the Pivot table or Pivot chart to your liking
Stop the macro recorder
Run the macro after each pivot refresh.
Bookmarks