Formating pivot table cells.

Hello,

I'm having problems with preserving format of a pivot table.

That's how it happens:

- I clear all the filters
- change e.g. font size of the first column
- apply one of the filters
- the format changes but it looks like these are
random changes - one cell has one format, the other
has different, one cell is alligned to the left, the other not and so
on.

I tried to apply "preserve format after update" (it may sound
different,
it's just my translation from polish) function but it both cases
formating looks random. I'd like to set my format and I want this
format to remain, independently of filtering and other changes.

Maybe pivot tables get the formating from outside? (e.g. source data)

What do you think?

Thanks for help.

Kris, Poland

You might want to post this in one of the Excel groups. You should probably
mention which version of Excel you're using when you do.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
(New!) The PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/2qzlpl
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/power...noy/index.html
PPTLive! Oct 28-31, New Orleans http://www.pptlive.com

<gongon@pf.pl> wrote in message
news:1192555399.881049.139000@e9g2000prf.googlegro ups.com...
> Hello,
>
> I'm having problems with preserving format of a pivot table.
>
> That's how it happens:
>
> - I clear all the filters
> - change e.g. font size of the first column
> - apply one of the filters
> - the format changes but it looks like these are
> random changes - one cell has one format, the other
> has different, one cell is alligned to the left, the other not and so
> on.
>
> I tried to apply "preserve format after update" (it may sound
> different,
> it's just my translation from polish) function but it both cases
> formating looks random. I'd like to set my format and I want this
> format to remain, independently of filtering and other changes.
>
> Maybe pivot tables get the formating from outside? (e.g. source data)
>
> What do you think?
>
> Thanks for help.
>
> Kris, Poland
>