I have a Live Office connected dashboard(Xcelsius 2008), in which I need to show dynamcally changing rows/columns of data from excel. The data in the excel will change dynamically as per the selection of some parameters in dashboard.
I understand that Table will not increase/decrease its selected row/column if the row/column in the excel change dynamically, rather table will just update the values in the selected range of cells in excel dynamically.
Is there any component in xcelsuis(like table, grid or list view) which can change the data range(displyed in dashbaord) selected in excel by itself?