When performing several, recursive, subsets of a Statistica data file (Statistica spreadsheet), the  header file of the new spreadsheet will display all the subset actions and fill up the header.  How can this be turned off?

For example, when using Subset in Statistica, multiple times, each subsequent header shows all the previous subset information:

This article discusses the use of DefOpts.xml to turn off subset output in header summary for workbooks.

Windows operating systems only.

Changing the DefOpts.xml will remove any subset information in summary header.

Add this to DefOpts.xml file:

<Edit SubsetsIncludeSourceInfo="0"> </Edit>

For example, this DefOpts.xml file will be changed from this:

<?xml version="1.0" encoding="utf-8" ?>
<StatOpts ActiveConfig="Initial">
    <Initial>
        <Edit SubsetThreadScalar="2" SubsetThreading="0" DefaultMissingDataVaue="-9999" ID_ENTRY_EXPORTHTML_SHOW_WARN="0" ExportXLS_IncludeFormatting="1" MaxAutoFitRows="12" MaxAutoFitCols="12" AutofitOnUpdateView="0">
            <FontsOpt />
            <RUFonts />
        </Edit>
        <General ID_ENTRY_MAIN_VERSIONNUMBER="13.0.0.0.1033" UseRibbonBar="0" AskSaveProject="0" LoadLastFile="2" SuppressReadOnlyWarning="0" WarningAppEvent="0" WarningDocEvent="0" />
        <Server Enabled="1" />
        <Graphics UseAdvancedDrawing="0" />
        <Macros>
            <MacroReferences Archive="2,64,3,mATTTTOTTTTTtyrN7F9FWQ91WvWHARZHbNZFAS96WF9NvjWHdYkFA4KFR1jFZ79CRAxWTOIBgFKM7B9MmT9HbHZ1jK96nAZ1jjPME4AFbTZHZRZFE7AHA8ZFmjVTRhTT" />
        </Macros>
        <Workbook WorkbookCompressGraphsAndReports="1" />
    </Initial>
</StatOpts>


...to this (the  SubsetsIncludeSourceInfo="0" is included):

<?xml version="1.0" encoding="utf-8" ?>
<StatOpts ActiveConfig="Initial">
    <Initial>
        <Edit SubsetThreadScalar="2" SubsetThreading="0" DefaultMissingDataVaue="-9999" ID_ENTRY_EXPORTHTML_SHOW_WARN="0" ExportXLS_IncludeFormatting="1" MaxAutoFitRows="12" MaxAutoFitCols="12" AutofitOnUpdateView="0" SubsetsIncludeSourceInfo="0">
            <FontsOpt />
            <RUFonts />
        </Edit>
        <General ID_ENTRY_MAIN_VERSIONNUMBER="13.0.0.0.1033" UseRibbonBar="0" AskSaveProject="0" LoadLastFile="2" SuppressReadOnlyWarning="0" WarningAppEvent="0" WarningDocEvent="0" />
        <Server Enabled="1" />
        <Graphics UseAdvancedDrawing="0" />
        <Macros>
            <MacroReferences Archive="2,64,3,mATTTTOTTTTTtyrN7F9FWQ91WvWHARZHbNZFAS96WF9NvjWHdYkFA4KFR1jFZ79CRAxWTOIBgFKM7B9MmT9HbHZ1jK96nAZ1jjPME4AFbTZHZRZFE7AHA8ZFmjVTRhTT" />
        </Macros>
        <Workbook WorkbookCompressGraphsAndReports="1" />
    </Initial>
</StatOpts>


Note:  Please see the reference to understand how DefOpts.xml and StatOpts.xml works.
 

https://support.tibco.com/s/article/How-to-propagate-Statistica-options-with-StatOpts-xml-and-DefOpts-xml