Re: pivot table formatting

KC - are you still with me?

Things are going well. I've modified my pivot table to pull from a dynamic
Named Constant so I can change the size of data inputted. Very cool.

My last bit of formatting angst is that I can't get the far right Total
column headings to keep their Bold format. Whever I press the refresh key,
the bold goes away. For these 2 fileds there is no "Black arrow" option. I
can make the arrow appear above the column, but then applying the bold format
would bold the data, and I only want the column heading to be bold.

I need to make this bullet-proof as I'm a contractor and will leave at some
point. I don't want the users to have to do anything more than paste in the
new data each month. Any ideas?

thx

"KC Rippstein" wrote:

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