Tag Archives: calculation speed

Why Structured References are slow in Excel 2013 but fast in Excel 2016

Posted on February 19, 2017 by fastexcel

Tables have a bad reputation for performance. Zack (Firefytr) Barresse (who wrote the definitive guide to Excel Tables with Kevin (Zorvek) Jones) recommends a limit of around 10K rows for tables if you want to keep performance reasonable. Prompted by … Continue reading →

Posted in Calculation | Tagged , , , , , | 5 Comments

Timing Excel Formula Calculations

Posted on May 11, 2015 by fastexcel

I have written a couple of posts previously about the methodology of timing Excel calculations: A Quantum of Time – measuring time accurately The XIPS Challenge – how fast does Excel calculate? But rather than focus exclusively on how to … Continue reading →

Posted in Calculation, Uncategorized | Tagged , , , | 3 Comments

Stacking (Appending) Arrays/Ranges in Excel: Formulas versus Functions Shootout

Posted on January 16, 2015 by fastexcel

This post is a follow up to my last post Using Constant Arrays and Expressions in Excel Formulas. I will explore how some of the general purpose array-handling functions in FastExcel SpeedTools Extras compare with formulas using native Excel functions. … Continue reading →

Posted in arrays, Calculation, Lookups, Uncategorized, XLL | Tagged , , , , , , , | 9 Comments

Calling XLAM/XLL/Automation UDFs from VBA: Evaluate, Run, or Reference?

Posted on December 13, 2014 by fastexcel

I have this nagging feeling that I do not know the best way to call UDFs from VBA. So after a couple of days of research here is what I have found out so far. The Available Methods Application.ExecuteExcel4Macro This … Continue reading →

Posted in Calculation, UDF, VBA, XLL | Tagged , , , , | 5 Comments

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

Threading and Hyper-Threading: Optimizing Excel Calculation speed by changing the number of threads

Posted on January 29, 2014 by fastexcel

I have just implemented measuring multi-threaded calculation efficiency in FastExcel V3 Profile Workbook: so I thought it would be interesting to see the effect on calculation speed of varying the number of threads, and switching off hyper-threading. Hyperthreading Almost all … Continue reading →

Posted in Calculation | Tagged , | 18 Comments