Any general or specific suggestions on ways to speed-up calculations in Excel workbooks? I usually work with large spreadsheets. I don't use VB functions, and I avoid array functions.
Are there any especially slow functions to avoid? I've heard the CHOOSE function is slower than the INDEX function.
What are your favorite tricks to speed-up the calculation or recalculation speed of a workbook?
Are there any organizational ways? Would using more cells with shorter formulas be faster than fewer cells with longer formulas?
Are there any especially slow functions to avoid? I've heard the CHOOSE function is slower than the INDEX function.
What are your favorite tricks to speed-up the calculation or recalculation speed of a workbook?
Are there any organizational ways? Would using more cells with shorter formulas be faster than fewer cells with longer formulas?