Pivot Table Formatting

[Phil vK]

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

 

[Shane Devenshire]

Hi Phil,

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

Cheers,
Shane Devenshire
Microsoft Excel MVP