Skip to Content
0
Former Member
Sep 17, 2008 at 12:41 PM

Running Preview changes data in Spreadsheet Table component

36 Views

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