SXDB: PivotTable Cache Data (C6h)

The SXDB is stored on a separate stream that maintains information about each PivotTable cache. The SXDB record is followed by a single SXDBEX record and several FDB records, one for each field in the PivotTable, given by cfdbTot.

Record Data — BIFF8

Offset

Name

Size

Contents

4

crdbdb

4

Number of records in database

8

idstm

2

Identifies the stream


Offset

Name

Size

Contents

10

grbit

2

= 01h, fSaveData — data is being saved with table layout.

= 02h, fInvalid — the PivotTable must be refreshed before the next update.

= 04h, fRefreshOnLoad — the PivotTable will be refreshed on load.

= 08h, fOptimizeCache — the cache is optimized to use the least amount of memory.

= 10h, fBackgroundQuery — results of the query are obtained in the background.

= 20h, fEnableRefresh — refresh is enabled.

12

crdbDbb

2

Number of records for each database block.

14

cfdbdb

2

Number of base fields in databases.

16

cfdbTot

2

Number of base fields, grouped fields, and calculated fields.

18

crdbUsed

2

This value is not used and can be set to zero.

20

vsType

2

Data source is one of:
1, Excel worksheet
2, External Data
4, Consolidation
8, Scenario PivotTable

22

cchWho

2

Number of characters in the string containing the name of the user who last refreshed the PivotTable.

24

rgb

(var)

String which is of length given by cchWho and represents the number of the user who last refreshed the PivotTable.