Share via

2.2.7.3 Supporting Link Record

  • Article

There are four types of supporting links, which are represented by the four types of supporting link records. The type of the supporting link used is specified by the type of supporting link record that is specified by the Xti (section 2.5.173). These supporting link types, and the corresponding supporting link record types, are defined in the following table.

Supporting link type

Supporting link record type

Meaning

Self-Referencing

BrtSupSelf (section 2.4.813)

A reference back into the same workbook.

This supporting link type supports cross-sheet references, where the target sheets are specified by the scope information in the Xti. This record can also support defined name or UDF reference on the same book, although using the PtgName (section 2.5.98.60) formula element (section 2.2.2.6) can be simpler.

Same-Sheet Referencing

BrtSupSame (section 2.4.812)

A reference to the active sheet in the context of the consuming formula (section 2.2.2).

This supporting link type is used by formula in macro sheets and in defined names to reference the sheet of the caller.

Add-in Referencing

BrtSupAddin (section 2.4.799)

A reference to a UDF on any Excel Linked Library (XLL) or COM automation add-in.

External Link Referencing

BrtSupBookSrc (section 2.4.800)

A reference to an external link (section 2.2.7.4).