Category Archives: Calculation

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

Only Calculating the Active Workbook

Posted on March 1, 2023 by fastexcel

When you have more than one workbook open Excel has always recalculated all of the workbooks at each recalculation. That can be very painful if one or more of the workbooks are slow to calculate. Now the Excel Dev Team … Continue reading →

Posted in Calculation, Excel | Tagged | Leave a comment

Excel Screen-updating Performance Comparison.

Posted on January 14, 2023 by fastexcel

The time that Excel takes to refresh the screen display can be a significant factor in overall processing speed. Things that affect screen updating Time My benchmarking workbook The workbook contains one sheet (Sheet1) with 4895 formulas and 1000 constants. … Continue reading →

Posted in Calculation | Tagged , | Leave a comment

Short-circuiting in Array Formulas

Posted on January 6, 2023 by fastexcel

The previous post demonstrated that IF and CHOOSE short-circuit but IFS and SWITCH do not. But following up a hint from Bill Wu that IF behaves differently in array formulas I decided to check whether it still short-circuits.(IF in array … Continue reading →

Posted in arrays, Calculation, Dynamic Arrays, Excel, UDF | Tagged | 3 Comments

Short-circuiting Excel Formulas: IF, CHOOSE, IFS and SWITCH

Posted on January 3, 2023 by fastexcel

What is formula short-circuiting? Short-circuiting occurs in Excel formulas when an IF statement only evaluates the True part of the IF and skips the False part of the IF. For example in this formula: Because 1>2 evaluates to False the … Continue reading →

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

FastExcel Version 4 – with Introductory Offer

Posted on February 5, 2020 by fastexcel

After several man-years of development and a lot of beta testing FastExcel Version 4 has finally hit general availability! FastExcel V4 is a major rewrite of FastExcel V3 and provides many of the things you have been asking for: Support … Continue reading →

Posted in arrays, Calculation, Debug formulas, Dynamic Arrays, Excel, Lookups, Memory, UDF, VBA | Leave a comment

Formula Explorer Pro Beta 4.2

Posted on January 8, 2019 by fastexcel

After another 6 months on my quest to create the worlds best tool for exploring, validating, debugging and editing Excel formulas I have made Explorer Pro Beta 4.2 build 418.796 available. Hopefully this will be the final Beta! The improvements … Continue reading →

Posted in Calculation, Debug formulas | Tagged , , , | 7 Comments

Excel JavaScript API Part 2: Benchmark of Read/Write Range Performance

Posted on March 13, 2017 by fastexcel

As an Excel Office Developer many of the Excel based applications I develop depend on reading data from Excel worksheet ranges, processing it and then writing the processed data back to a worksheet. In VBA the way to do this … Continue reading →

Posted in arrays, Calculation, JS-API, VBA | Tagged , , | 3 Comments

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 Versions Screen Test (Updated): how fast is Screen Updating?

Posted on December 14, 2016 by fastexcel

Gurs has an interesting benchmark he has been running on various systems and Excel versions over the years. His results seem to show a massive performance decline in later Excel versions. Looking at his benchmark and its VBA code you … Continue reading →

Posted in Calculation, Formatting, Uncategorized, VBA | 9 Comments