I have read past posts on Pivot Table formatting and have achieved some
success with the formatting problem.  

My current problem is that on one spreadsheet I have used AutoFormat to get
the look I want for the Pivot Table.  On this table I expanded the width of
the columns and the formatting has held in place. I then created a new and
separate spreadsheet file using the former one as a template.  Everything
looks great, except on this file, every time I refresh,  the columns go back
to the default width.  I have tried enabling selection before widening the
columns with no luck.

Any help is always appreciated.  I am using Excel 2002 and XP Home