Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2010 MultiThreadedCalculation Incompatible with Range.Calculate
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2010: Parent of a Range can be a Shape? | Excel Programming | |||
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
passing range to function: type of argument is byref incompatible | Excel Programming | |||
Incompatible "allow users to edit range" in earlier Excel versions | Excel Discussion (Misc queries) |