ExcelBanter - Refresh Option

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Refresh Option (https://www.excelbanter.com/excel-discussion-misc-queries/36211-refresh-option.html)

macdva094

Refresh Option

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

aristotle

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?

All times are GMT +1. The time now is 08:42 PM.