Hi,
I regularly use this kind of call:
=SUMPRODUCT(ABS(Intraday.K$1:K$99885))
which before I upgraded to version 6 (and in Excel) gives you the sum of absolute values. It now gives #VALUE. Is this a bug / is there a workaround? Thanks, regards,
Unexpectedly, to answer this, one needs not only the formula, but also the contents of Intraday.K$1:K$99885, or a sample document. 
First, I’d check if some of the cells contain text instead of numbers, and in Options→Calc→Formula→Detailed Calculation Settings, Custom is set, with Conversion from text to number generating $VALUE error.
Ensure that the range does not contain a Text type (string) cell, even if it may look like a number. You can adjust the on-the-fly text conversion settings under Tools → Options → Calc → Formula → Detailed Calculation Settings → Custom → Details → Contents to Numbers → Conversion from text to number, but I’d rather suggest to convert the data instead, see this FAQ.
my apologies - there was a cell with text in, which didn’t seem to bother previous versions but broke after update. Thank you very much!
Some earlier versions (5.3 or so) erroneously did not propagate an error in array/matrix context (which SUMPRODUCT forces to its arguments) under some circumstances, this might had been the reason why you didn’t see it before.