OpenDef Worksheet

 

The OpenDef worksheet is located as the last worksheet in the workbook. It is probably needed in very rare cases only. The worksheet contains on the left hand side  the actual used mapping for the columns. The default value is 1 which means that Excel interprets the value on its own. On the right hand side  the pre-defined values for the respective report type are listed. If you need to define your own mapping please only enter a 2 for each column which should be interpreted as a string value in the “By Definition”  row of the table. In the example shown below the 2s are the same as for the “LPAR Activity Report”.