Hello.

I have a subroutine that creates a Pivot Table which has 10 row fields.

It then goes through and turns off all of the subtotaling for the 10 row
fields.

Each time a row field's subtotal is turned off, it recalcs the Pivot Table
before moving on to removing the next total.

I woudl like for it to not recalc, but then recalc the Pivot Table only at
the end.

Is there a setting that I can turn off? I tried setting the
application.recalculation property to xlmanual, but that did not affect the
Pivot Table.

Thanks,
Mark