Monthly Archives: November 2013

Bordeaux Wine Tasting: the ones that got away

Posted on November 28, 2013 by fastexcel

Saturday evening (after I got back from Seattle: the Microsoft MVP Summit ) there was a major Bordeaux wine tasting event planned. My ex-neighbour Joe had initiated this, explaining that he had this bottle of Haut Brion that needed drinking. … Continue reading →

Posted in Wine | 1 Comment

Summit Winter 2013

Posted on November 26, 2013 by fastexcel

On Saturday I got back from the winter 2013 MVP summit at the Microsoft campus in Redmond. The summit is a great chance to talk to the Microsoft Excel teams and to meet up with other Excel MVPs. I also … Continue reading →

Posted in Uncategorized | 6 Comments

Formula References between Sheets versus within Sheets shootout: Which calculates faster and uses more Memory

Posted on November 8, 2013 by fastexcel

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 →

Posted in Calculation, Memory, VBA | Tagged | 1 Comment

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