Suppressing Pivot Table totals

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

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)
 
Hi Tom

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

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summarsing Variable Pivot Table Data 1
Format Pivot total rows 2
create a calculated field for pivot tables 2
Suppress sub totals on pivot table 2
Formatting calculated totals in a Pivot Table 1
Name of Pivot Table 3
Corrupt files due to pivot remnants after saving via VBA 0
VBA Pivot Table Error 1

Back
Top