Build 2.9.0.69 of xlsgen adds a Worksheet property to the IXlsDynamicRange interface making it possible, when enumerating existing named ranges, to know if the named range in question has a local scope or not (its scope is limited to a single worksheet), and accordingly retrieve the name of the worksheet in question. All non local named ranges have a global scope, in which case the worksheet property returns an empty string.