Prev: Excel 2010 - Save as XML
Next: Sumproduct with multiple date criteria
From: EricG on 27 May 2010 17:03
Right-click anywhere in the pivot table and select "Pivot Table Options...".
Make sure the box that says something like "Preserve Cell Formatting on
Change" is checked. Your formatting should stay the way it is.

You might also want to un-check the box that is labelled something like
"Autofit Column Contents on Change" so that your column widths always stay
the same.

HTH,

Eric


"Greg" wrote:

> Is there a way to format a pivot table and when the data is refreshed the
> formatting stays. Currently I change the formatting and then the next time I
> refresh it reverts back to the original format
 | 
Pages: 1
Prev: Excel 2010 - Save as XML
Next: Sumproduct with multiple date criteria