Creating the dynamic table already in Excel instead of letting the table generated automatically has the advantage that you can use formulas with reference to the dynamic table and furthermore the table can be configured.
The most important
Named ranges and table names used in this section (overview):
- Named range =
data1_CELLS01_InsertTable_T_DIMxxx - Table name =
data1_CELLS01_Table_T_DIMxxx
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"
Important:
Please make sure that this named range does NOT reference to a table object ("Table[[#Headers];[DIM001.KEY]]") BUT to a cell ("$B$5"). - The table must be named
"data1_CELLS01_Table_T_DIMxxx" - The table should contain no data but only one empty row (if it contains data then this data will be removed before loading the table)
Customizing of the table
Basically, the dynamic table is created with those columns that are set to visible in the data model of your application.
If you define the table as described here, you can remove (or leave) the columns that are not necessary for your workbook.
At this stage calculated columns cannot be configured (but this is planned).