Pivot table questions

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
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top