Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

2.1.7.20.3 Globals Substream

Office

The Globals Substream specifies global properties and data in a workbook.

There MUST be exactly one Globals Substream in a Workbook Stream (section 2.1.7.20), and the Globals Substream MUST be the first substream in the Workbook Stream.

Record sequence<5><6> ABNF:

WORKBOOKCONTENT = [WriteProtect] [FilePass] [Template] INTERFACE WriteAccess [FileSharing] CodePage *2047Lel DSF [Excel9File] RRTabId [ObProj] [ObNoMacros] [CodeName] [FNGROUPS] *Lbl [OleObjectSize] PROTECTION 1*Window1 Backup HideObj Date1904 CalcPrecision RefreshAll BookBool FORMATTING *(PIVOTCACHEDEFINITION) [DOCROUTE] *UserBView UsesELFs 1*BUNDLESHEET METADATA [MTRSettings] [ForceFullCalculation] Country *SUPBOOK *LBL *RTD [RecalcId] *HFPicture *MSODRAWINGGROUP [SHAREDSTRINGS] ExtSST *WebPub [WOpt] [CrErr] [BookExt] *FeatHdr *DConn [THEME] [CompressPictures] [Compat12] [GUIDTypeLib] EOF

WORKBOOK = BOF WORKBOOKCONTENT

INTERFACE = InterfaceHdr Mms InterfaceEnd

FNGROUPS = BuiltInFnGroupCount *FnGroupName *FnGrp12

PROTECTION = WinProtect Protect Password Prot4Rev Prot4RevPass

FORMATTING = 1*510Font 8*218Format XFS *DXF STYLES [TABLESTYLES] [Palette] [ClrtClient]

XFS = 16*XF [XFCRC 16*4050XFExt]

STYLES = 1*(Style [StyleExt])

TABLESTYLES = TableStyles *(TableStyle *28TableStyleElement)

PIVOTCACHEDEFINITION = SXStreamID SXVS [SXSRC] [SXADDLCACHE]

SXSRC = DREF / SXTBL / DBQUERY

DREF = DConName / DConBin / DConRef

SXTBL = SXTbl *DREF *SxTbpg *(SXTBRGIITM *SXString)

DBQUERY = DbOrParamQry [1*SXString [DbOrParamQry *(SXString DbOrParamQry)]] *SXString

DOCROUTE = DocRoute 1*65535RecipName

BUNDLESHEET = BoundSheet8

METADATA = *MDTINFO *MDXSTR *(MDXTUPLESET / MDXProp / MDXKPI) *MDBLOCK

MDTINFO = MDTInfo *ContinueFrt12

MDXSTR = MDXStr *ContinueFrt12

MDXTUPLESET = (MDXTuple / MDXSet) *ContinueFrt12

MDBLOCK = MDB *ContinueFrt12

SUPBOOK = SupBook [*ExternName *(XCT *CRN)] [ExternSheet] *Continue

LBL = Lbl [NameCmt] [NameFnGrp12] [NamePublish]

RTD = RealTimeData *ContinueFrt

MSODRAWINGGROUP = MsoDrawingGroup *Continue

SHAREDSTRINGS = SST *Continue

THEME = Theme *ContinueFrt12

SXADDLCACHE = SXAddl_SXCCache_SXDId SXAddl_SXCCache_SXDVer10Info [SXAddl_SXCCache_SXDVerSXMacro] [SXADDLCACHE12] [SXADDLDBQUERY] *UNKNOWNFRT SXAddl_SXCCache_SXDEnd

SXADDLCACHE12 = SXAddl_SXCCache_SXDVerUpdInv SXAddl_SXCCache_SXDInfo12 SXAddl_SXCCache_SXDInvRefreshReal *SXADDLCACHEFIELD [SXADDLSXDH] [SXADDLSXMGS] SXAddl_SXCCache_SXDVerUpdInv

SXADDLSXDH = SXAddl_SXCSXDH_SXDId *SXAddl_SXCSXDH_SXDSxdh SXAddl_SXCSXDH_SXDEnd

SXADDLSXMGS = SXAddl_SXCSXMgs_SXDId *SXADDLSXMG *SXAddl_SXCSXMgs_SXDMGrpSXDHMap *UNKNOWNFRT SXAddl_SXCSXMgs_SXDEnd

SXADDLSXMG = SXAddl_SXCSXMg_SXDId *Continue_SxaddlSxString [SXAddl_SXCSXMg_SXDUserCaption *Continue_SxaddlSxString] *UNKNOWNFRT SXAddl_SXCSXMg_SXDEnd

SXADDLCACHEFIELD = SXAddl_SXCCacheField_SXDId *Continue_SxaddlSxString [SXAddl_SXCCacheField_SXDCaption *Continue_SxaddlSxString] [SXAddl_SXCCacheField_SXDProperty [SXAddl_SXCCacheField_SXDPropName *Continue_SxaddlSxString]] [SXAddl_SXCCacheField_SXDIfdbMpMapCount SXAddl_SXCCacheField_SXDIfdbMempropMap] [SXAddl_SXCCacheField_SXDSxrmitmCount *SXADDLCACHEITEM SXAddl_SXCCacheItem_SXDEnd] SXAddl_SXCCacheField_SXDEnd

SXADDLCACHEITEM = SXAddl_SXCCacheItem_SXDId [SXAddl_SXCCacheItem_SXDSxrmitmDisp *Continue_SxaddlSxString] *(SXAddl_SXCCacheItem_SXDItmMpMapCount SXAddl_SXCCacheItem_SXDItmMpropMap)

Show: