Amazon VBA Manuel d'utilisateur télécharger pdf (Page 55)

285

Using New Pivot Table Features in Excel 2007

Changing the Layout

The Layout group of the Design ribbon contains four drop-downs. These drop-downs con-

trol the location of subtotals (top or bottom), the presence of grand totals, the report layout,

and the presence of blank rows.

Subtotals can appear either at the top or bottom of a group of pivot items. The

SubtotalLocation property applies to the entire pivot table; valid values are xlAtBottom or

xlAtTop:

PT.SubtotalLocation:=xlAtTop

Grand totals can be turned on or off for rows or columns. The following code turns them

off for both:

PT.ColumnGrand = False

PT.RowGrand = False

There are three settings for the report layout. The Tabular layout is similar to the default

layout in Excel 2003. The Outline layout was optionally available in Excel 2003. The

Compact layout is new in Excel 2007.

Excel can remember the last layout used and will apply it to additional pivot tables created

in the same Excel session. For this reason, you should always explicitly choose the layout

that you want. Use the

RowAxisLayout method; valid values are xlTabularRow, xlOutlineRow,

xlCompactRow:

Previous versions of Excel offered an AutoFormat feature for pivot tables.This feature was annoying

because it actually changed the layout of your pivot table.That obsolete command used the

TableStyle property; hence,Excel 2007 had to use TableStyle2 as the property name for the

new style tables.

NOTE

It is possible to create custom table styles. If you have a custom table style named MyStyle44 and

use this name in a macro,the macro will run fine on your computer but may not run on anyone

else’s computer.To alleviate the chance of a runtime error, you use On Error Resume Next

before applying TableStyle2.

CAUTION

To apply a table style from the gallery, use the TableStyle2 property. If you want to get the

correct name, it might be best to record a macro:

‘ Format the pivot table

PT.ShowTableStyleRowStripes = True

PT.TableStyle2 = “PivotStyleMedium3”

In Figure 11.24, the ToolTip shows a style named Pivot Style Medium 3.

12_0789736012_CH11.qxd 12/11/06 6:26 PM Page 285

1 2 ... 50 51 52 53 54 55 56 57 58 59 60

Commentaires sur ces manuels

Pas de commentaire

Modelle	Dokumententyp
HPS50	Bedienungsanleitung Velleman HPS50 User Manual, 72 Seiten
LAB2	Bedienungsanleitung Velleman LAB2 User Manual, 32 Seiten
PCS10	Bedienungsanleitung Velleman PCS10 User Manual, 7 Seiten
BPAPS230	Bedienungsanleitung Velleman BPAPS230 User Manual, 2 Seiten
LAB1	Bedienungsanleitung Velleman LAB1 User Manual, 64 Seiten
PCSU1000 RECORDER	Bedienungsanleitung Velleman PCSU1000 RECORDER User Manual, 7 Seiten
PCS100A pcs100 - pcs500 - k8031	Bedienungsanleitung Velleman PCS100A pcs100 - pcs500 - k8031 User Manual, 25 Seiten
PCGU1000	Bedienungsanleitung Velleman PCGU1000 User Manual, 13 Seiten
PCSGU250	Bedienungsanleitung Velleman PCSGU250 User Manual, 40 Seiten
VDP900HZ2	Bedienungsanleitung Velleman VDP900HZ2 User Manual, 28 Seiten
VDP1500SM	Bedienungsanleitung Velleman VDP1500SM User Manual, 19 Seiten
VDL800SMT2	Bedienungsanleitung Velleman VDL800SMT2 User Manual, 23 Seiten
PMLCD	Bedienungsanleitung Velleman PMLCD User Manual, 7 Seiten
VDL400SM	Bedienungsanleitung Velleman VDL400SM User Manual, 19 Seiten
VDP1000SWN	Bedienungsanleitung Velleman VDP1000SWN User Manual [en] , 16 Seiten

Amazon VBA Manuel d'utilisateur Page 55

Commentaires sur ces manuels

Velleman WEH200 Handbücher

Velleman WEH200 Bedienungsanleitung (16 Seiten)

Inhaltsverzeichnis

Weitere Produkte und Handbücher für Ausrüstung Velleman

Amazon VBA Manuel d'utilisateur Page 55

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Amazon VBA

Velleman WEH200 Handbücher

Velleman WEH200 Bedienungsanleitung (16 Seiten)

Inhaltsverzeichnis

Weitere Produkte und Handbücher für Ausrüstung Velleman