ExcelBanter - Pivot Table - Preserve Formatting

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

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

- - Pivot Table - Preserve Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/114147-pivot-table-preserve-formatting.html)

WCM

Pivot Table - Preserve Formatting

Excel 2003/WinXP:

In my pivot table, the Table Options Preserve Formatting is checked.
However, if I set the the 'Total' column in the pivot table to to bold, it
reverts back to regular (not-bold) every time I refresh the pivot table.

Does anyone know how to make the 'Total' column retain its bold setting,
even after a refresh? Thanks for your help ..

Bill

All times are GMT +1. The time now is 02:16 PM.