Tag Archives: calculation methods

Manual Calculation No Longer Viral!

Posted on March 14, 2023 by fastexcel

Excel has 3 basic calculation modes: Automatic, Manual and Automatic except Tables. But an Excel session can currently only have one Calculation mode (unless you are using FastExcel which allows open workbooks and their worksheets to have different Calculation Modes). … Continue reading →

Posted in Calculation | Tagged , | Leave a comment

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

Excel Circular References: Calculation, Detection, Control and Removal

Posted on September 14, 2015 by fastexcel

Circular references in Excel are generally bad news: They are slow to calculate They can be hard to detect An intentional circular reference can mask an unintended circular reference, They do not always converge The Status Bar always shows calculate … Continue reading →

Posted in Calculation | Tagged , , , | Leave a comment

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

Exploring Range.Calculate and Range.CalculateRowMajorOrder: fast but quirky formula calculation

Posted on November 3, 2013 by fastexcel

The Range.Calculate methods are very useful additions to Excel’s other calculation methods (Application level Calculate, CalculateFull, CalculateFullRebuild and Worksheet.calculate: the missing one is Workbook.Calculate!). You can use the Range Calculate methods to: Force calculation of a block of formulas or … Continue reading →

Posted in Calculation, VBA | Tagged , | 2 Comments