Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Query
I am building Pivots on the fly all works well but, how do turn off or remove
the row totals at the moment I have to right click and hide is there a way to do this when my code builds the pivot. TIA Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Query
Turn on the macro recorder while you do it manually. This should give you
the code you need. -- Regards, tom Ogilvy "Frank" wrote in message ... I am building Pivots on the fly all works well but, how do turn off or remove the row totals at the moment I have to right click and hide is there a way to do this when my code builds the pivot. TIA Frank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Query
Hi Frank,
I'm assuming you have written the code to generate Pivot Table from your raw data. The following code will hide the row totals. pt.PivotFields("myRowField").Subtotals = Array(False, False, False, False, False, False, False, False, False, False, False, False) Give it a try and see if it works Joe "Frank" wrote: I am building Pivots on the fly all works well but, how do turn off or remove the row totals at the moment I have to right click and hide is there a way to do this when my code builds the pivot. TIA Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table and MS Query | Excel Discussion (Misc queries) | |||
a query for pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) |