Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.2.5.4.10 PivotTable Layout

2.2.5.4.10 PivotTable Layout

Office

The PivotTable report (section 2.2.5) in the sheet (2) has four main areas: the row area (section 2.2.5.4.10.1.1), the column area (section 2.2.5.4.10.1.2), the data area (section 2.2.5.4.10.1.4), and the page area (section 2.2.5.4.10.1.3).

Dd944937.54cad76a-5e2c-40ae-b215-1b8515a7d7d7(en-us,office.12).jpg

Figure 15: PivotTable report illustrating the four different areas

All the records described here MUST exist in the same worksheet substream (section 2.1.7.20.5).

Show:
© 2015 Microsoft