Category Archives: Memory

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

Excel Memory Checking Tool: Using LAA to increase useable Excel memory

Posted on November 27, 2016 by fastexcel

Most of us sooner or later get hit by one or more of the dreaded messages “Out of Memory” or “Excel cannot complete this task with available resources” or “Not enough System Resources/Memory to Display Completely” , regardless of how … Continue reading →

Posted in Memory, VBA | Tagged , , , , | 10 Comments

Excel Full Column References and Used Range: Good Idea or Bad Idea?

Posted on December 12, 2015 by fastexcel

Some people love using full column references such as A:A, other people say they slow down your workbook to a crawl and lead to workbook and memory bloat. The attraction of using whole column references is that you don’t have … Continue reading →

Posted in arrays, Calculation, Formatting, Memory | 5 Comments

Excel ForceFullCalculation: Trading off Editing speed vs Calculation speed

Posted on May 19, 2015 by fastexcel

A recent post at Stack Overflow reminded me that I have not posted about the pros and cons of Excel’s Workbook.ForceFullCalculation property. So what does Workbook.ForceFullCalculation do? The simple answer is that it switches off Excel’s smart recalculation algorithm, so … Continue reading →

Posted in Calculation, Memory, Uncategorized, VBA | Tagged | 10 Comments

FastExcel V3 Released with Introductory Offer

Posted on June 10, 2014 by fastexcel

FastExcel has been used successfully by thousands of users since it was first launched in 2001. The last version 2.4 was introduced in 2008 and since that time there have been major changes to Excel with Excel 2007, 2010 and 2013, … Continue reading →

Posted in Calculation, Lookups, Memory, UDF, VBA, XLL | Leave a comment

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