Setting Pivot Table default Field Settings using Template or similar

[MegastarMagus]

I create a lot of what I believe are very simple Pivot Tables using a lot of different data sources. I am not experienced in the PowerExcel/PowerPivot options.

Each of my Pivot Tables is comprised of different amounts and complexities of data and have different Record/Field names.

My issue is with having to change the Field Settings from Subtotals/Automatic to Subtotals/None.

I understand that a Book Template can be created for the style of the Pivot Table (I watched video 2405!), but can the Field Setting be set in that Template?
Is there a macro that can be run to make the Field Settings change to a default value at the start of every Pivot Table?

Thanks, in advance!

Data:

Interim - Aug 3 - DSC04300-63rd 01-03 1831- GenScriber 2021-08-02.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Regimental Number	Rank	Lastname	Firstname	Period-from-year	Period-from-month	Period-from-day	Period-to-year	Period-to-month	Period-to-day	2s7d per diem	2s1d per diem	1s11d per diem	1s5d per diem	Days on board Ship	Reason - 1st Muster
2	143	Sergeant	Mackey	Edward	1831	4	1	1831	6	30				90
3	143	Sergeant	Mackey	Edward	1831	4	1	1831	6	30				90
4	143	Sergeant	Mackey	Edward	1831	4	1	1831	6	30				90
5	143	Sergeant	Mackey	Edward	1831	4	1	1831	6	30				90
6	143	Sergeant	Mackey	Edward	1831	7	1	1831	9	30				92		On Guard
7	143	Sergeant	Mackey	Edward	1831	10	1	1831	12	31				92		On Guard
8	143	Sergeant	Mackey	Edward	1831	10	1	1831	12	31				92		On Guard
9	143	Sergeant	Mackey	Edward	1832	1	1	1832	3	31				91		On Guard
10	143	Sergeant	Mackey	Edward	1832	4	1	1832	6	30				91		Eagle Hawk Neck
11	143	Sergeant	Mackey	Edward	1832	7	1	1832	9	30				92
12	143	Sergeant	Mackey	Edward	1832	10	1	1832	12	31				92		On Guard
13	143	Sergeant	Mackey	Edward	1833	1	1	1833	3	31				90		On Guard
14	143	Sergeant	Mackey	Edward	1833	4	1	1833	6	30				91
15	143	Sergeant	Mackey	Edward	1833	7	1	1833	9	30				92
16	143	Sergeant	Mackey	Edward	1833	10	1	1833	12	31				83
17	143	Sergeant	Mackey	Edward	1834	1	1	1834	3	31						on Board ISABELLA
DSC04300-63rd 01-03 1831- GenSc

Table created

Period-from-year	Lastname	Firstname	Rank
1831	Mackey	Edward	Sergeant
1832	Mackey	Edward	Sergeant
1833	Mackey	Edward	Sergeant
1834	Mackey	Edward	Sergeant
1838	Mackey	Edward	Private
1839	Mackey	Edward	Private
1840	Mackey	Edward	Private
Grand Total

 

[RoryA]

File - Options, Data section, click the Edit Default Layout button, and you can set a lot of defaults there. There's also a button on the pivot tables design tab to remove all subtotals.

 

[MegastarMagus]

Yes, I've seen that, but that does not answer my problem.

When I select the components to fill my Pivot Table, I can select up to 10 components and maybe more. In order to turn off the subtotalling for the component, I have to click through each component, Select the field heading (either row or column label), open the Field Settings, set the calculation to None, from Automatic. Doing this every time I create a Pivot Table, which I do maybe 15 times a day, means that I have to go through that process for each Pivot table component on each Pivot table I create.

If there is a way to set the Field Setting for Calculation to None that would save me so much time and effort, and reduce the click-stress on my mouse-arm!

 

[RoryA]

You can turn off subtotals in the default layout options, so I'm not sure what else you want. Also, the button on the toolbar removes subtotals for all fields in the pivot table, so is a lot quicker than what you are describing.

 

[MegastarMagus]

Well, that might be my problem - I can not read (or understand) where to turn off subtotals!!!!!

FOUND IT - thank you, RoryA - it works!

 

[RoryA]

Glad to help.