Eric,

For a pivot table, you can turn off AutoFormat, and it should prevent
changes to the column widths --

Right-click a cell in the pivot table
Choose Table Options
Remove the checkmark from AutoFormat table.
Ensure that there's a checkmark in Preserve formatting.
Click OK

Excel GuRu wrote:
> Debra,
> I'm experiencing the same issues with preserving formats in pivot tables.
> I've never been a big fan of recording macros. Is ther a way to use visual
> basic code to preserve the formats. Perhaps as the pivot table was refreshed
> you could reapply formats? I'm not trying to do anything funky with my
> formats, biggest pet peeve being that the column witdth always changes. Eric
>
> "Debra Dalgleish" wrote:
>
>
>>This is a known problem with pivot charts. There's some information in
>>the following MSKB article, which suggests recording a macro as you
>>apply the formatting:
>>
>>
>>Changing a PivotChart removes series formatting in Excel
>> http://support.microsoft.com/?id=215904
>>
>>
>>
>>dblack wrote:
>>
>>>After establishing all desired fonts, text alignments, and data series
>>>colors/patterns within a pivot chart, I cannot preserve the settings. As I
>>>change a selection in a page field button on the chart, the data series
>>>revert back to default color settings.
>>>
>>>Any autoformat options I can toggle on/off?
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html