Pivot Table Formatting

[slhughes01]

I am currently working with Excel 2004 for the Mac and created a pivot
table which worked fine. However, I made a number of format changes to
make the report look better and whenever I refresh the data I lose all
the formatting.

I have the 'Preserven Formatting' option selected for this pivot table
but alas that is not working. The amount of time it will take to
reformat this everytime I need to refresh is simply too time consuming.


Has anyone had or heard of this problem before. I'm stumped and need a
solution. Thanks much!

 

[Jim Gordon MVP]

Hi

I'm almost certain that Microsoft knows about this problem.

There's a good chance it could be fixed in a future update. Meanwhile,
you could record a macro that restores the formatting that you desire.

-Jim

 

[CyberTaz]

Hhello-
\
Just a quick checkout, so not completely confirmed, but try clicking the
Pivot Table button on the PT toolbar, select Table Properties, and remove
the check to AutoFormat Table.

HTH |:>)