Skip to Content
Former Member
May 10, 2011 at 12:58 PM

Adjust Range in Xcelsius dynamically



is there a possibility adjust the range in the excel sheet in xcelsius dynamically depending on a SAP BW query result?

I allready established a Connection between SAP BW and the excel sheet of xcelsius. The problem I encounter now is that the range does not automatically change in case the result of the query changes and I don't want to define manually the range where the data is displayed in Xcelsius every time.

Instead the range should adjust dynamically to the query data. For instance if the query result consists of 100 lines the range should be A1 to A100 and change dynamically with the result of the query without having to modify the range manually.