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.


Thanks
Matt



Rick J wrote:
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

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1