Works OK for me.

Can you post the formulae you are using?

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"Mrburns" wrote in message
...
In 2007 if you use a conditional sumproduct that refers to another
conditional sumproduct then the parent sumproduct will not calculate (even
with auto on) unless you amend a condition or F2 or save as to a new file
name.

F9 etc has no impact on the summed amount even though the child calculated
correctly. Parent sits there and does not listen.

Have tried with threads on/ off single processor /dual.