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

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

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

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

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