Right-click on the pivot table, and choose Table Options.
Turn off AutoFormat table, and your formatting should stick

CMDMHHS wrote:
Hi Debra,

Thanks for the response. Is there anyway to permanently override the pivot
table formatting? I find that whenever I use pivot tables/charts, if I try to
use any custom formatting (for example, resizing the columns so they fit
better when printed, using colors to highlight certain totals, etc), my
formatting is eliminated when the pivot table is refreshed.


"Debra Dalgleish" wrote:


Instead of filters and subtotals, you could create a pivot table to
summarize the data. There are examples and links he

http://www.contextures.com/xlPivot01.html

CMDMHHS wrote:

I am creating a spreadsheet that several different people (who all want to
see different aspects of the spreadsheet) need to use. I want to be be able
to use the autofilter so that the various people can easily and quickly zero
in on ONLY the information that they want to see, but then the SUBTOTAL
functions get messed up. I do not want to use the SUM functions because there
are so many subtotal lines it would be difficult to specify what needs be
included/excluded in a SUM function.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html