ExcelBanter - Formatting Pivot Report

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

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

- - Formatting Pivot Report (https://www.excelbanter.com/excel-discussion-misc-queries/182498-formatting-pivot-report.html)

FARAZ QURESHI

Formatting Pivot Report

Every time I change the color or border on the pivot table/report cells the
same is removed back to default upon refresh. How to overcome such a problem?

--

Best Regards,
FARAZ A. QURESHI

RobN[_2_]

Formatting Pivot Report

In PivotTable OptionsLayout & Format, select Preserve cell formatting on
update.

Rob

"FARAZ QURESHI" wrote in message
...
Every time I change the color or border on the pivot table/report cells
the
same is removed back to default upon refresh. How to overcome such a
problem?

--

Best Regards,
FARAZ A. QURESHI

All times are GMT +1. The time now is 11:17 AM.