Suppressing Pivot Table totals
 

Is there any way to supress the display of pivot table totals ... i have

External Date AAABA 3
AAABB 5
AAABC 7
External Date Total 15
Internal Date AAABA 2
Internal Date Total 2

and i don't want to see the total lines ... preferably i would like to
supress this either permanently (for the workbook) or via code.
Additionally, are there any good website (other references) which have vba
examples of creating / manipulating pivot tables.

Cheers
julieD

Suppressing Pivot Table totals
 

ActiveSheet.PivotTables("PivotTable1"). _
PivotFields("Header1").Subtotals = Array _
(False, False, False, False, False, False, _
False, False, False, False, False, False)

--
Regards,
Tom Ogilvy


"JulieD" wrote in message
...
Is there any way to supress the display of pivot table totals ... i have

External Date AAABA 3
AAABB 5
AAABC 7
External Date Total 15
Internal Date AAABA 2
Internal Date Total 2

and i don't want to see the total lines ... preferably i would like to
supress this either permanently (for the workbook) or via code.
Additionally, are there any good website (other references) which have vba
examples of creating / manipulating pivot tables.

Cheers
julieD

Suppressing Pivot Table totals
 

There's code here to turn off the subtotals:

http://www.contextures.com/xlPivot03.html#Subtotals

There are links to pivot programming sites he

http://peltiertech.com/Excel/Pivots/pivotvba.htm

JulieD wrote:
Is there any way to supress the display of pivot table totals ... i have

External Date AAABA 3
AAABB 5
AAABC 7
External Date Total 15
Internal Date AAABA 2
Internal Date Total 2

and i don't want to see the total lines ... preferably i would like to
supress this either permanently (for the workbook) or via code.
Additionally, are there any good website (other references) which have vba
examples of creating / manipulating pivot tables.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Suppressing Pivot Table totals
 

Hi Tom

thanks works great!
took me a few mins to figured out how to get the name of the pivot table :)

Cheers
JulieD

"Tom Ogilvy" wrote in message
...
ActiveSheet.PivotTables("PivotTable1"). _
PivotFields("Header1").Subtotals = Array _
(False, False, False, False, False, False, _
False, False, False, False, False, False)

--
Regards,
Tom Ogilvy


"JulieD" wrote in message
...
Is there any way to supress the display of pivot table totals ... i have

External Date AAABA 3
AAABB 5
AAABC 7
External Date Total 15
Internal Date AAABA 2
Internal Date Total 2

and i don't want to see the total lines ... preferably i would like to
supress this either permanently (for the workbook) or via code.
Additionally, are there any good website (other references) which have
vba
examples of creating / manipulating pivot tables.

Cheers
julieD

Suppressing Pivot Table totals
 

Hi Debra

thanks for this ...

Regards
JulieD

"Debra Dalgleish" wrote in message
...
There's code here to turn off the subtotals:

http://www.contextures.com/xlPivot03.html#Subtotals

There are links to pivot programming sites he

http://peltiertech.com/Excel/Pivots/pivotvba.htm

JulieD wrote:
Is there any way to supress the display of pivot table totals ... i have

External Date AAABA 3
AAABB 5
AAABC 7
External Date Total 15
Internal Date AAABA 2
Internal Date Total 2

and i don't want to see the total lines ... preferably i would like to
supress this either permanently (for the workbook) or via code.
Additionally, are there any good website (other references) which have
vba
examples of creating / manipulating pivot tables.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html