Search

Recent Posts
 The Amsterdam Excel Summit
 Threading and HyperThreading: Optimizing Excel Calculation speed by changing the number of threads
 Inserting a UDF and Launching the Function Wizard from VBA
 2013 in review
 Excel 2013 SDI Bug: “Calculate” in Status Bar strikes again
 Finding out if a function is Volatile or Multithreaded using VBA: UDFs for UDFs
 Bordeaux Wine Tasting: the ones that got away
 Summit Winter 2013
 Formula References between Sheets versus within Sheets shootout: Which calculates faster and uses more Memory
 Exploring Range.Calculate and Range.CalculateRowMajorOrder: fast but quirky formula calculation
Recent Comments
VBA speed in XL2013x… on Getting Cell data with VBA and… Jonathon Power on Threading and HyperThreading:… fastexcel on Threading and HyperThreading:… Jonathon Power on Threading and HyperThreading:… Harold Petrich on Excel 2013 SDI Bug: “Cal… Harold Petrich on Exploring Conditional Format P… David Wilkinson on From VBA to C Part 4 – A… fastexcel on From VBA to C Part 4 – A… Post Archive
 February 2014 (1)
 January 2014 (3)
 December 2013 (2)
 November 2013 (4)
 October 2013 (6)
 September 2013 (4)
 February 2013 (3)
 January 2013 (3)
 December 2012 (4)
 November 2012 (2)
 October 2012 (2)
 September 2012 (1)
 July 2012 (6)
 June 2012 (7)
 April 2012 (1)
 March 2012 (2)
 February 2012 (1)
 January 2012 (3)
 December 2011 (1)
 November 2011 (3)
 October 2011 (2)
 September 2011 (2)
 August 2011 (1)
 July 2011 (4)
 June 2011 (8)
 May 2011 (4)
Categories
Blogroll
RSS
Blog Stats
 188,517 hits
 Follow Excel and UDF Performance Stuff on WordPress.com
Category Archives: Calculation
Threading and HyperThreading: Optimizing Excel Calculation speed by changing the number of threads
I have just implemented measuring multithreaded 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 hyperthreading. Hyperthreading Almost all … Continue reading
Excel 2013 SDI Bug: “Calculate” in Status Bar strikes again
In the old days (I’m talking Excel 5 to Excel 2003 here) there was a worrying situation you could find yourself in where, no matter what you did, Excel would show you “Calculate” in the statusbar. Even when actually nothing … Continue reading
Posted in Calculation, VBA
4 Comments
Finding out if a function is Volatile or Multithreaded using VBA: UDFs for UDFs
Part of my new Profiling Formulas and Functions command requires the code to determine whether a Function is a native builtin Excel function, or an XLL function, or some other kind (VBA, Automation). And I also want to know if … Continue reading
Posted in Calculation, UDF, VBA, XLL
Leave a comment
Formula References between Sheets versus within Sheets shootout: Which calculates faster and uses more Memory
I thought I would revisit the differences between formulas that reference other worksheets and formulas that only reference their own worksheet. Referencing other worksheets always used to be a memory hog, but so much has changed between Excel 2003 and … Continue reading
Exploring Range.Calculate and Range.CalculateRowMajorOrder: fast but quirky formula calculation
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
Parsing Functions from Excel Formulas using VBA: Is MID or a Byte array the best method?
As part of extending the performance profiling abilities of FastExcel, I wanted to develop a Function Profiler Map. A key component of this is to extract the names of the functions embedded in Excel formulas. So I experimented with some … Continue reading
Posted in Calculation, VBA
Leave a comment
Exploring Conditional Format Performance Part 3: What’s slow, whats buggy and whats faster!
This is the third in a series of Posts on Conditional Formats (see part 1 and Part2). This post looks at the effects on the performance of Conditional Formats of: Application.Screenupdating Application.EnableConditionalFormatsCalculation Application.Calculation Whether the cells containing the conditional formats … Continue reading
Posted in Calculation, Formatting, UDF, VBA
Tagged conditional formats bugs, conditional formats slow
4 Comments
Exploring Conditional Format Performance Part 2: What’s slow, whats buggy and whats faster!
This is the second in a series of Posts on Conditional Formats (see part 1). This post looks at the effects (and the resulting bugs!) on Conditional Formats of: Application.Screenupdating Application.EnableConditionalFormatsCalculation Application.Calculation Whether the cells containing the conditional formats are … Continue reading
Posted in Calculation, Formatting, UDF, VBA
Tagged conditional formats bugs, conditional formats slow
Leave a comment
Exploring Conditional Format Performance Part 1: What’s slow, whats buggy and whats faster!
Patrick wanted to know if I had any information on Conditional Format calculation and performance, and I have not looked at it for several years, so here goes! I have done a series of experiments, using Excel 2007, 2010 and … Continue reading
Posted in Calculation, Formatting, UDF, VBA
Tagged conditional formats bugs, conditional formats slow
Leave a comment