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 and 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

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

see response to your posting in another ng.

--
Regards
Roger Govier



wrote in message
oups.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 and 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

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