Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Classic PivotTable Layout
I wish there was a default setting to force pivot tables to use the "classic"
layout, but failing that, I'm looking to create a macro that runs whenever a pivot table is created. I've got this code that works, but only within the current workbook. How do you get Excel to automatically recognize when a pivot table is being created to change the layout to classic? With ActiveSheet.PivotTables("PivotTable1") .InGridDropZones = True .RowAxisLayout xlTabularRow End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
classic pivottable layout | New Users to Excel | |||
Can I switch from Office 2007 layout to the old 2003 layout? | Excel Discussion (Misc queries) | |||
Default PivotTable Layout | Excel Worksheet Functions | |||
Change Pivottable layout through VBScript | Excel Programming | |||
Save the layout of PivotTable | Excel Programming |