Export (0) Print
Expand All
Expand Minimize

2.4.317 SXVS

Office

The SXVS record specifies the type of source data used for a PivotCache. This record is followed by a sequence of records that specify additional information about the source data.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

sxvs

sxvs (2 bytes): An unsigned integer that specifies the type of source data used for the PivotCache. The types of records that follow this record are dictated by the value of this field. MUST be a value from the following table:

Name

Value

Meaning

SHEET

0x0001

Specifies that the source data is a range. This record MUST be followed by a DConRef record that specifies a simple range, or a DConName record that specifies a named range, or a DConBin record that specifies a built-in named range.

EXTERNAL

0x0002

Specifies that external source data is used. This record MUST be followed by a sequence of records beginning with a DbQuery record that specifies connection and query information that is used to retrieve external data.

CONSOLIDATION

0x0004

Specifies that multiple consolidation ranges are used as the source data. This record MUST be followed by a sequence of records beginning with an SXTbl record that specifies information about the multiple consolidation ranges.

SCENARIO

0x0010

The source data is populated from a temporary internal structure. In this case there is no additional source data information because the raw data does not exist as a permanent structure and the logic to produce it is application-dependent.

Show:
© 2014 Microsoft