## Manual Calculation No Longer Viral!

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

## Only Calculating the Active Workbook

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

## Excel Screen-updating Performance Comparison.

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

## Short-circuiting in Array Formulas

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

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 | | 3 Comments

## Finding VBA Bottlenecks with VBA Profiler

When you are faced with slow-running or complex VBA projects it can be very helpful to have a tool that allows you to time the individual parts of your code or trace the execution path as event-driven jumps occur. Googling … Continue reading

Posted in Uncategorized | 1 Comment

## Excel Virtually Global

https://excelvirtuallyglobal.com/ Tue 21 July to Thu 23 July 2020 Microsoft’s Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get … Continue reading

## FastExcel Version 4 – with Introductory Offer

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