Column width of Pivot Table data goes back to default when data refreshed

[Rick J]

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

 

[Mattlynn via OfficeKB.com]

go to the pivot table options, untick auto-refresh, and make sure preserve
formatting is ticked

 

[Rick J]

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



| 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
|
|
|

 

[Mattlynn via OfficeKB.com]

Rick - sorry my mistake.
Untick, Auto Format Table and tick preserve formatting. Refresh on open
should also be unticked.

This should do the trick, as it works for my pivot models.
Thanks
Matt

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

| go to the pivot table options, untick auto-refresh, and make sure preserve
| formatting is ticked
[quoted text clipped - 11 lines]
| >Thanks,
| >Rick

 

[Rick J]

Matt,

I guess what I am figuring out is that I cannot use the "Table 8" format for
my pivot table and maintain the reduced column width. The problem is that I
am grouping days into weeks (7 days) so the labels across the top of the
table look like "12/05/2007 - 12/12/2007". Even though the labels are
rotated 90 degrees therefore the column does not need to be very wide, the
default column width remains wide enough to accommodate the long label if it
were horizontal. For a years worth of information that is a veeeerrrry wide
table that has no chance of being printed on one page of paper. I will just
need to adjust the column widths when I refresh or print. Thanks for you
help.

Rick


| Rick - sorry my mistake.
| Untick, Auto Format Table and tick preserve formatting. Refresh on open
| should also be unticked.
|
| This should do the trick, as it works for my pivot models.
| Thanks
| Matt
|
|
| Rick J wrote:
| >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
| >
| >| go to the pivot table options, untick auto-refresh, and make sure
preserve
| >| formatting is ticked
| >[quoted text clipped - 11 lines]
| >| >Thanks,
| >| >Rick
|
| --
| Matt Lynn
|
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200809/1
|

 

[Mattlynn via OfficeKB.com]

Rick - i just recreated an example like you gave with 90 degree orientaed
text, and my table column width did not move on refresh.
Did you want to email lme your model, and i will take a look, as there is
probably something making this happen.

(e-mail address removed)
Thanks
Matt

Matt,

I guess what I am figuring out is that I cannot use the "Table 8" format for
my pivot table and maintain the reduced column width. The problem is that I
am grouping days into weeks (7 days) so the labels across the top of the
table look like "12/05/2007 - 12/12/2007". Even though the labels are
rotated 90 degrees therefore the column does not need to be very wide, the
default column width remains wide enough to accommodate the long label if it
were horizontal. For a years worth of information that is a veeeerrrry wide
table that has no chance of being printed on one page of paper. I will just
need to adjust the column widths when I refresh or print. Thanks for you
help.

Rick

| Rick - sorry my mistake.
| Untick, Auto Format Table and tick preserve formatting. Refresh on open
[quoted text clipped - 20 lines]
| >| >Thanks,
| >| >Rick