- Does your Excel spreadsheet require minutes to re-calculate?
- Or even worst, does Excel crash during recalculation - with or without an out-of-memory error?
- Are your macros so slow, that you run them only during lunch breaks or overnight?
If Excel recalculation is at the top of your 'pet-hate' list, then please read on, before you rush to upgrade PC memory or buy a new computer!
The following list is a compilation of articles describing techniques that Excel developers can use to design complex worksheets with optimized calculation performance:
- Recalculation in Microsoft Excel 2002
- Improving Performance in Excel 2007
- Excel 2010 Performance: Improving Calculation Performance
