Excel logger cwxtndxl.ini parameters

Hi there

There are a few parameters in the Pulse Excel Logger ini:


Apart from the obvious ones what are these parameters used for?


Hi @dfranken,



    • This is to enable/disable the check for a certain named range in determining whether an Excel sheet is a TM1 workbook
    • It simply checks for the Named Range: TM1REBUILDOPTION, if it is available on a worksheet

    • To trigger a sheet recalculation on the first worksheet
    • Some prefer to put settings on the first worksheet to determine the correct Admin Host / Environment, hence this setting
      • This also enables the Excel Logger to correctly grab the correct username in the worksheet, especially those workbook whose Excel environment is set to Manual calculation
      • For performance consideration in order to not trigger a full workbook calculation

    • The area of rows / columns used in checking the type of worksheet is

The diagnostics section is optional, and you can remove that from the INI file. The ENABLE_DEBUG is the parameter we would usually be asking to be set to true to enable extra logging of information for investigating/troubleshooting issues.