Tag Archives: Excel 2010 Calculation Bug

Timing the Ins and Outs of User Defined Functions: Multi-Cell array formulas can be slow

Posted on October 24, 2014 by fastexcel

I was looking at some multi-cell array formula UDFs with John and Rich and could not understand why they seemed so much slower than I expected. Each UDF (written as C++ XLLs) read data from around 200 cells using around … Continue reading →

Posted in Calculation, UDF, Uncategorized, VBA, XLL | Tagged , , , , , | Leave a comment

Table Extension recalculation bug in Excel 2010 but not 2007

Posted on October 11, 2012 by fastexcel

gizzzzmo has found an unexpected recalculation bug in Excel 2010. You can duplicate it using the following steps. Start Excel 2010 with a new blank workbook in Automatic Calculation mode. in A1 enter =MAX(A4:A5) in A2 enter =A1 in A3:A5 … Continue reading →

Posted in Calculation | Tagged | 8 Comments