Re: pivot table formatting

Exactly. Sorry, I was out to lunch...glad you figured it out. I was going
to mention your first point. When you are working with a pivot table,
forget the fact that it's on a work***...the work*** itself is actually
rather irrelevant for the most part. Virtually all your formatting and
properties are attributed to your OBJECT (the various areas of the pivot
table itself) rather than to the work***. Same thing with charts,
pictures, and other objects you work with in Excel.
Good job!

"xrbbaker" <xrbbaker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3EE5E8A1-9F29-4CAE-8FCF-D309B57EA1B2@xxxxxxxxxxxxxxxx
FIgured it out!

In order to get the column width and wrap-text formatting to "stick" I
must:

1) do NOT select the whole work*** column. Instead hover the mouse
above
the tope of the PT column until it turns into a black down arrow

-AND-

2) then right mouse click on the now highlighted column and select Format
Cells. Seems like if I use the Format Cells from the main menu the
formatting doesn't stick.


"KC Rippstein" wrote:

There was another checkbox for "Auto Format" 2 positions above the
checkbox
for "Preserve Formatting". Whenever you check "Preserve Formatting", you
need to uncheck "Auto Format" in order to stop that behavior.

"xrbbaker" <xrbbaker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:86BBC398-9E13-41D4-A83D-FFA3AB62EDE5@xxxxxxxxxxxxxxxx
Using 2003 (11.5612.8107)

This is my first real work with a pivot table. In 10 minutes I was
able
to
create a beautiful table with exactly the desired look. However if
there
is
any slight change, I have to rebuild things from scratch or at least
reformat
it. For example in the left most (Row field) i use Request Type. If I
change the Request Types being displayed, the format of the table comes
undone.

I have read an old post and selected Pivot Table, Table options,
Preserve
Formatting. I've also clicked on Select, Enable selection. Yet if I
add
or
remove one of the items to display and all the column widths need
resetting.

Is this normal PT behavior? It makes it unviable if I can't lock it
down.

Thanks much,

Russ





.

Loading