2.4.85 DConName

The DConName record specifies a named range that is a data source for a PivotTable or a data source for the data consolidation settings of the associated sheet. The range is specified as a reference to an external workbook or a defined name in this workbook. If the named range is in an external workbook, this record specifies the path to the external workbook. If the named range has a defined name that has a sheet-level scope, this record also specifies the name of the sheet that contains the range.


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

stName (variable)

...

cchFile

stFile (variable)

...

unused (variable)

...

stName (variable): An XLNameUnicodeString structure that specifies a defined name for the source range.

cchFile (2 bytes): An unsigned integer that specifies the character count of stFile. MUST be 0x0000, or greater than or equal to 0x0002. A value of 0x0000 specifies that the defined name in stName has a workbook scope and is contained in this file.  

stFile (variable): A DConFile structure that specifies the workbook, or workbook and sheet, that contains the range specified in stName. This field exists only if the value of cchFile is greater than zero. If the defined name in stName has workbook scope, this field specifies the workbook file that contains the defined name and its associated range. If the defined name in stName has a sheet-level scope, this field specifies both the sheet name and the workbook that contains the defined name and its associated range.

unused (variable): An array of bytes that is unused and MUST be ignored. MUST exist if and only if cchFile is greater than 0 and stFile specifies a self-reference (the value of stFile.stFile.rgb[0] is 2).  If the value stFile.stFile.fHighByte is 0, the size of this array is 1.  If the value of stFile.stFile.fHighByte is 1, the size of this array is 2.