Matt - thanks for the response. I went to pivot table options but did not
find "auto-refresh." I did find "Refresh on Open" and unchecked it as well
as unchecked "Auto format table." I checked "Preserve Formatting." When I
apply the Table 8 format then reduce the column width it still goes back to
the original column width when I refresh the data. All other formatting
appears to be preserved other than column width. Hmmm.... any other
suggestions? I'm using Excel 200 at home and Excel 2003 at work - not sure
if there is a difference when it comes to this issue.

Rick



"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:8a1e506f56dc3@uwe...
| go to the pivot table options, untick auto-refresh, and make sure preserve
| formatting is ticked
|
| Rick J wrote:
| I have generated a pivot table and then applied one of the auto table
| formats (Table 8 I believe in Excel 2003). The width of the columns is
too
| wide therefore I manually decrease the width of the columns of the data
| field. Unfortunately, every time that I refresh the pivot table the
column
| widths return to the default "wide" width. Other formatting that I apply
| seem to remain (such as filling in cells with a color). This occurs even
if
| I do not apply any of the auto table formats format to the pivot table.
Is
| there a way to keep the column widths from returning to the default width
| after I have adjusted them?
|
| Thanks,
| Rick
|
| --
| Matt Lynn
|
| Message posted via http://www.officekb.com
|