Right-click on a cell in the pivot table and choose Table Options
Make sure that the Preserve Formatting box is checked.

LordCommando wrote:
On 9 avr, 22:14, Debra Dalgleish wrote:

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings
Format the selected headings





I does work, I tried it but the change is not permanent. If I refresh
again, I will lose formatting again, back to square one... :) Maybe
I'm missing something...

Lord Commando Of The Styx



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html