Thanks for that will give it a go.

M

"Debra Dalgleish" wrote:

Right-click a cell in the pivot table, and choose Table Options
Add a check mark for Preserve Formatting, and turn off AutoFormat.
Click OK

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. subtotals --
Move the pointer to the left of a subtotal heading in the pivot table.
When the black arrow appears (like the one that appears when the pointer
is over a row button), click to select the subtotal rows
in the pivot table.
Format the selected subtotals


Marlyn wrote:
Is there a way that you can get colour/font formating of a pivot table to
remain after a refresh without the autoformat functions?

"Marlyn" wrote:


I am looking to create a pivot table format that i can apply as an auto format.

Is this possible?

Marlyn



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