2010 MultiThreadedCalculation Incompatible with Range.Calculate

[NDeanMeyer]

Excel 2010 becomes unstable when Application.MultiThreadedCalculation.Enabled = True and when Range.Calculate is used in VBA. Sometimes it locks up during the calculation. Sometimes it crashes upon the next <F9> recalc. Sometimes it locks up on saving the workbook.

My application employs lots of UDFs, and memory arrays which pass data from one UDF to another. It works impeccably in Excel 2003 and 2007.

Patch: I set "Application.MultiThreadedCalculation.Enabled = False" before a "Range.Calculate" and back on afterwards. That seems to solve the problem.

Does anybody know anything about this?

(Cross-posted on microsoft.public.excel.programming.)

 

[AdamRoff]

dear mr meyer. bless your cotton socks. lord knows how you figured this was what was causing your instability but it has solved my mystery crashing problem.

i basically have the same situation - workbook rich with udf's some of which are array functions shunting large quantities of data into and out of the front end. crashing, although replicable, is unpredictable. as in you can always get a crash at some known conditions,but what causes those conditions to be unstable is unclear.

i couldn't find your parallel post on the other forum. any response there?