Creating the dynamic table already in Excel instead of letting the table generated automatically has the advantage that you can have reference with formulas to the dynamic table and furthermore the table can be configured.
The most important
Table name used in this section (overview):
How to do
Instead of letting the Web Client generate the dynamic table at the named cell "data1_CELLS01_InsertTable_T_DIMxxx", you can create the table object manually alreay in the Excel file:
The easiest way of doing this is copying the automatically generated table from the Web Client into the Excel file. Make sure to follow those rules:
- The first cell of the table object must be on the named range cell "data1_CELLS01_InsertTable_T_DIMxxx"
- The table must be named "data1_CELLS01_Table_T_DIM001"
- The table should contain no data but only one empty row
At this stage the table object cannot be configured (but this is planned).