Preserving Highlights in Pivots

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am having trouble in a pivot because when i change a criteria I lose all
the colors I have in the pivot, is there a way I can make the colors stick?
 
What are the highlight being used for. Are you highlighting exception data or
are you just trying to format the table for presentation purposes???
 
Presentation purposes.

Jim Thomlinson said:
What are the highlight being used for. Are you highlighting exception data or
are you just trying to format the table for presentation purposes???
Click to expand...
 
Have you looked at the auto formats that come with pivot tables. On the
Pivot Tables Toolbar there is an icon that looks like a table with a
lightning bolt. There are a bunch of predefined formats that work great. They
format the entire table quick and easy.
 
Jim,

When I choose an auto format for the pivot table, the box that is checked in
the table options for auto format becomes checked again. I need that box to
be unchecked because my tables width changes. I need the tables widths not to
change. Is there a way to lock the column widths?
 
That has always been an issue. I have gotten around it using a hidden row
above the pivot table. Add text to the cells such that the size is defined by
the width of the text in these cells. Hide the row and all is well.
 
Jim,

I still have the problem of it widening more then what I define. for example
I want it to be this long HHHHH, when i update the pivot it expands to this
(HHHHH______________).
 
Back
Top