SXNAME: PivotTable Name (F6h)

This records stores a PivotTable name.

Record Data — BIFF8

Offset

Name

Size

Contents

4

grbit

2

= 02h, fErrName, the name is invalid and should be displayed and evaluated as #NAME.

6

ifdb

2

Field to aggregate in calculated field formulas.

8

ifn

2

Function to use for aggregation in calculated field formulas.

= 01h, SUM
= 02h, COUNTA
= 03h, COUNT
= 04h, AVERAGE
= 05h, MAX
= 06h, MIN
= 07h, PRODUCT
= 08h, STDEV
= 09h, STDEVP
= 0Ah, VAR
= 0Bh, VARP

10

csxpair

2

Number of SXPAIR records to follow this record.