View Single Post
  #1   Report Post  
Joel 48371
 
Posts: n/a
Default Retain PivotTable formatting after "Refresh Data"

PivotTable formatting changes each time the "Refresh Data" button is clicked.
It is very frustrating to have SOME formatting changes each time the data is
refreshed. The last Row Field column always changes width, the "Total"
heading in Data Items always resets to top, left align, unbold, box borders,
and no fill. Is there a formatting method that RETAINS the formatting?