Hi,

Could anyone explain the Pivot Table options Format Report and Preserve
Formatting and how they affect any formats you put on a pivot tables.

I have a pivot table which is refreshed every day. It has Row, Column and
Page selections but the formatting I apply changes after refreshes.

Has anyone tamed the Pivot Table Beast and could point me in the right
direction?

Ta...

Neily