ExcelBanter - preserve formatting option in pivot table

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

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

- - preserve formatting option in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/132022-preserve-formatting-option-pivot-table.html)

The Rook[_2_]

preserve formatting option in pivot table

I have formatted a pivot table to the way I would like it and have the
preserve formatting option ticked, but when I refresh the formatting is lost.

Is there anyway of saving it?

Regards

Phil vK

preserve formatting option in pivot table

I have been trying to find the answer to this for YEARS!! Good luck.

"The Rook" wrote:

I have formatted a pivot table to the way I would like it and have the
preserve formatting option ticked, but when I refresh the formatting is lost.

Is there anyway of saving it?

Regards

All times are GMT +1. The time now is 04:43 AM.