Speeding up your Excel worksheets
Having complex formulas and repetitive cell references usually slows down the performance speed of your Excel application especially if the amount of calculations are huge. To make things fast and simple, the following tips could come of great help:
- Start by reducing the number of cell references in every formula to the bare minimum unless it is unavoidable
- Sorting the data before performing look ups and using the most efficient function will help reduce runtime. Preferably use user defined functions instead of arrays
- Avoid using volatile functions, Excel usually recalculates with each function even if their is nothing to be recalculated.
- Use more rows and columns to store immediate values. Avoid using complex formulas and arrays.
19th January 2018
3rd December 2009
1st December 2009