Is they a way of turning off the "Subtotals" in columns and rows from the
start of creating the pivot table? In my Excel the option is greyed out under
Pivot Table OptionsTables & Filters .

Currently the only way I can find too turn them of is individually as I add
the column or row to the pivot table.

Any assistance is greatly appreciated.