Pivot table question

G

Guest

When I drag to add pivot table field, some of my fields defaults to Count
instead of Sum.I have to go and change it every time manually.
Also, some fields loses formatting when I add to pivot table and have to
reformat by double clicking it.Is there a way to lock formatting and also
lock defaulted to sum? Thanks for your help.
 
G

Guest

regarding the format you should the table the way you want it to appear then
uncheck the "autoformat table" under PivotTable options
 
G

Guest

regarding the format you should format the table the way you want it to
appear then uncheck the "autoformat table" under PivotTable options
 

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

Similar Threads

Pivot Table Shows Only Zeros 3
about pivot table 1
Pivot Table - Changes 5
pivot table data 2
Different ways to build Pivot table 1
Pivot table filter list - listing irrelevant subcategorys 1
how to partially protect a pivot table based worksheet 8
Pivot table formulas 1

Top