Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to display Tabular View of Active Pivot Table
Is there some basic code that would allow me to quickly convert the
active Pivot table to "tabular form" (i.e., the same as choosing Design Report Layout Show in Tabular Form). Even better would be displaying the Pivot table in Tabular Form with no subtotals....but just the above will suffice as well. Thx for any suggestions... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to display Tabular View of Active Pivot Table
Pls check if it helps.Will be expecting your feedback.
------------------------------------------------------------- Just ensure that you select one cell in PivotTable. ------------------------------------------------------------ Sub SDPivotCustomize() Dim PT As PivotTable, PC As PivotCell, PF As PivotField Application.ScreenUpdating = True Set PC = ActiveCell.PivotCell Set PT = PC.PivotTable For Each PF In PT.PivotFields PF.Subtotals = Array(False, False, _ False, False, False, False, False, _ False, False, False, False, False) Next PF PT.RowAxisLayout xlTabularRow Application.ScreenUpdating = False End Sub -------------------------------------------------------------------- Not tried to optimize because much benefit will not be available. --------------------------------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you view an active macro code? | Excel Discussion (Misc queries) | |||
omit dialog box display during pivot table refresh (macro) | Excel Programming | |||
Pivot Table Macro - How to describe the Active range (so that themacro can be used on new sets of data) | Excel Programming | |||
Set Pivot Table Tabular Form to Default | Excel Discussion (Misc queries) | |||
Macro (or equivalent) to display certain pivot table data | Excel Discussion (Misc queries) |