Array formulas vs. Pivots
Posted on 2002-07-16
I am attracted to the apparent benefits of array fromulas, and I am interested in substituting them for some of my simple pivots. I have some very large spreadsheets with over 20 pivots in them. They take forever to recalc and are 30 mb when done. I run out of memory, so we wrote VB to close and re-start Excel after half of the pivots are calculated.
I know this shouldn't be in Excel, but it is and I cannot change that.
Will array formulas instead of pivots reduce file size (10,000 rows of source data)?
Will array formulas instead of pivots run faster?
Will array formulas instead of pivots use less RAM and therefore not require re-starting Excel to reclaim memory?