Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you view an active macro code? Scott Excel Discussion (Misc queries) 4 February 9th 10 07:53 PM
omit dialog box display during pivot table refresh (macro) cm Excel Programming 4 September 17th 09 07:31 PM
Pivot Table Macro - How to describe the Active range (so that themacro can be used on new sets of data) Dave K Excel Programming 1 February 9th 08 05:22 AM
Set Pivot Table Tabular Form to Default [email protected] Excel Discussion (Misc queries) 0 July 16th 07 08:17 PM
Macro (or equivalent) to display certain pivot table data Becky Excel Discussion (Misc queries) 8 May 21st 07 07:40 PM


All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"