Hi I have a spread sheet has quite a lot of formulas in it,
eg..
=COUNTIF()
=COUNT($H$2:$H$65536)-COUNTIF($H:$H,"<51")-COUNTIF($H$2:$H$65536,">60")
=DCOUNTA($A$1:$L$15099,10,M38:N39)
=IF(V18=0,0,IF(V18=1,IF(W18=0,0,IF(W18=1,IF(X18=0,0,IF(X18=1,1))))))
=IF(SUM(V18:W18,$BD18)=3,1,0)
=SUMIF($L$2:$L$65536,BN6,$U$2:$U$65536)
=SUMIF($BC:$BC,$BS2,BE:BE)
all of which seem to be supported in xcelcius engage 2008 (sp3)
but when i try to preview the dash board I get the "an error occurred during swf generation and so on" error
I have checked all of my addins on excel and disabled them all,
I have checked to see if there is any blue tooth settings in the registry, (all seems ok (none))
Does xcelcius have limitations on file size? My file is 23,852KB
My calculations are based on a maximum of 15000 rows
I'm desperate for some kind of solution as this has now been driving me nuts for 5 days
Steve