This record stores information about multiple-consolidation PivotTable source data.
Record Data
Offset |
Name |
Size |
Contents |
4 |
cdref |
2 |
Count (1-based) of DCONREF or DCONNAME records that follow the SXTBL record |
6 |
csxtbpg |
2 |
Count (1-based) of SXTBPG records that follow the DCONREF or DCONNAME records |
8 |
grbitPages |
2 |
(See the following table) |
The grbitPages field contains an encoded count of page fields, as shown in the following table.
Offset |
Bits |
Mask |
Name |
Contents |
0 |
14–0 |
7FFFh |
cPages |
Count (1-based) of page fields |
15 |
8000h |
fAutoPage |
= 1 if the user selected the Create A Single Page Field For Me option in the PivotTable Wizard dialog box |