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: |
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. |