Pivot Tables and Formatting

[Neily]

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

 

[Debra Dalgleish]

In some versions of Excel, you may have to enable selection (From the
Pivot toolbar, choose PivotTable>Select, and click on Enable Selection)

Before formatting cells, use the selection feature to select the cells.
For example, move the pointer to the top of a column in the pivot table
(just above the column's heading cell). When the black arrow appears
(like the one that appears when the pointer is over a column button),
click to select the column in the pivot table. Then apply the formatting.

If that doesn't work, you could record a macro as you refresh and
reformat the pivot table. Then, run that when you want to update.

 

[Neily]

Cheers Debra,

I found the black arrow thing and thought I had conquered it, but it started
to misbehave. I'll try the other thing from the Pivot Tabe menu.

Ta.