Monday, August 20, 2012

Improving Excel 2010 Performance

Since Excel 2007 we've had the "Big Grid" available - meaning over 1000 times the amount of cells than in older Excel versions.

This brings challenges in keeping the performance good while amount of data and formulas increase.

Read Microsoft's article Excel 2010 Performance: Improving Calculation Performance to get a better understanding of the calculation logic and how to improve you workbooks performance.