Pivot table questions

  • Thread starter Thread starter Francesco
  • Start date Start date
F

Francesco

2 questions:

1)I created a custom pivot table format, but I am unable to use it for other
documents than the one I created it into.
Any idea on how to do it? I would like to use this style for every single
pivot table I create.

2) When I create a pivot table from a data (numbers) sheet, I always display
the numbers in the pivot report as "sum of" and not "count". How do I set
this to be the standard format? When having a lot of colums in the pivot,
it's quite a waste of time to change all of them in "sum of" from "count".

Thanks

Francesco
 
In Excel 2007 you can create custom pivot table styles, but not in
earlier versions. You could record a macro as you format the pivot
table, then modify the macro to make it generic. Run that macro to
format other pivot tables.

2) You can't change the default summary function for pivot tables. If a
field in the source data contains blank cells or text, it will default
to Count Of if you add it to the data area. If a field is all numbers,
it will default to Sum Of.

There's an add-in here that you can download. It has a command that will
set all the data fields to Sum.
http://www.contextures.com/xlPivotAddIn.html
 
Back
Top