Skip to Content

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

Running Preview changes data in Spreadsheet Table component

I have inserted a Spreadsheet Table component in my Xcelsius 2008 canvas, but when I click on "Preview" the data in the table changes from that which was originally in the spreadsheet. This is the only component on the canvas of a newly created model. I have gone through my Excel spreadsheet and replaced all of the functions that may be causing problems (e.g. Sumif, Dynamic Named Ranges using Offset) etc. so that the spreadsheet now only contains fairly basic formulae. The area which seems to be causing the problem includes the following formula:

=IF(AND(ISBLANK($J3),$H3<=O$2,$I3>=O$2),

ROUND(($G3*O$1)/4,0),

IF(AND($H3<=O$2,EDATE($J3,3*$K3)>=O$2),

ROUND(($G3*O$1)/4,0),0))+IF($M3=O$2,$L3,0)

but these are all supported functions. Any idea what may be causing this?

Thanks

Ronnie

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question