Pivot Table Default Setting

R

Registrar

Can you change the default setting in Pivot Table? For Example if everytime I
do a pivot table I do not want it to give me subtotals can I default it that
way instead of always changing the setting.
 
M

Matt S

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.
 

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

Dates In Excel 5
Problem with printing a word document containing a table 0
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Changing defauls in 2019 0
Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0
How can I save directly into the same folder every time in Office 365 / Windows 10? 0

Top