No Pivot Table Totals Wanted

Is it possible to get pivot to not put the totals in for the Row area besides going to each field and saying none under the "Field Settings"? I put these pivot tables together, and everytime I have to go back and change the field settings so I get no totals. I don't want the totals. I thought through the table options by taking the checks out of the grand totals and auto format it would take care of it but it doesn't. Just getting tired of changing those settings individually each time. Any ideas is there a way I hope someone has something or maybe I am going brain dead let me know which please.
Thanks,
Bob

Hi Bob

Try downloading Debra Dalgleish's new Pivot Table Addin
http://www.contextures.com/xlPivotAddIn.html

--
Regards

Roger Govier


"robertjtucker" <[email protected]>
wrote in message
news:[email protected]...
>
> Is it possible to get pivot to not put the totals in for the Row area
> besides going to each field and saying none under the "Field Settings"?
> I put these pivot tables together, and everytime I have to go back and
> change the field settings so I get no totals. I don't want the totals.
> I thought through the table options by taking the checks out of the
> grand totals and auto format it would take care of it but it doesn't.
> Just getting tired of changing those settings individually each time.
> Any ideas is there a way I hope someone has something or maybe I am
> going brain dead let me know which please.
> Thanks,
> Bob
>
>
> --
> robertjtucker
> ------------------------------------------------------------------------
> robertjtucker's Profile:
> http://www.excelforum.com/member.php...o&userid=21805
> View this thread: http://www.excelforum.com/showthread...hreadid=392278
>