Hi,

Right click the pivot table and go to table options. You should be able to
choose "preserve formatting" amongst the options.

Regards,
A
--
Please rate my response if you found it helpful. Thanks.


"macdva094" wrote:

In Excel HelpIndexRefresh, Refresh data in a PivotTable or PivotChart
Report. Is there a fix for lost Formatting?