View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Francesco Francesco is offline
external usenet poster
 
Posts: 5
Default Pivot Table Questions

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