Hi,
I am using dashboard designer v4.1 SP4. In my dashboard, I am using a structured (excel) table that contains my “raw” data (the data is imported into this table from an external excel-file). I am trying to use structured references to select data (column-wise, for index/match…) from this table, using table_name[column_name].
As the table needs to be updated (montly append), I would like to use these structured references rather than (absolute) range references. For the latter, I would need to count rows etc. to dynamically generate references, which (as we all know) is rather complicated due to the unavailability of the “indirect” function. Gosh.
However, when I save the dashboard (to plattform or disk), these structured references are “automatically” converted to A1-style range references. Gosh.
Is there any way of keeping the structed (table) references? I already deactivated the Excel “optimization” option under settings…
Thanks a lot for you help!
oliverd (BOB member since 2014-10-07)