- 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: