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

Hi Phil,

Select the pivot table and choose Pivot Table, Table Options, and uncheck
AutoFormat table.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Phil vK" <PhilvK@discussions.microsoft.com> wrote in message
news:544C3C3D-BE25-4AF5-9F9D-9D0EF06338A6@microsoft.com...
> 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
>