Tag Archives: Excel 2010 Calculation Bug

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

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

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