Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Live Office and database changes

Hi Guys,

I have created a Live Office connection to extract my Webi Report into the Xcelsius Spreadsheet. This is how the data looks in the spreadsheet.

Dept Name               No. of Projects

A                                        1

B                                        2 

C                                        3

Sum:                                  6

I have mapped the spreadsheet data to a pie chart component.

Now, let's say a new Dept Name is added/removed in the database, then that would happen to my Spreadsheet data? Could anyone please help understand the process?

Former Member
replied

You have to assume a maximum no of rows possible and bind the rows into excel accordingly in LO connection. Otherwise, always max 3 departments can be shown in above case.

By default the binding happens automatically considering the current number of rows in the block. You have to change that. Ensure you change the footer binding too so that it does not overlap with rows binding.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question