Forum Discussion
Can drop down lists slow down Excel?
The source of the validation lists might be the issue. Are you using dynamic items to supply the validation source?
Here's what Microsoft says:
Conditional formats and data validation
Conditional formats and data validation are great, but using a lot of them can significantly slow down calculation. If the cell is displayed, every conditional format formula is evaluated at each calculation and when the display of the cell that contains the conditional format is refreshed. The Excel object model has a Worksheet.EnableFormatConditionsCalculation property so that you can enable or disable the calculation of conditional formats.
Excel performance - Tips for optimizing performance obstructions | Microsoft Learn
The above article pre-dates dynamic arrays but has some good information.
The source of the validation lists might be the issue. Are you using dynamic items to supply the validation source?
Here's what Microsoft says:
Conditional formats and data validation
Conditional formats and data validation are great, but using a lot of them can significantly slow down calculation. If the cell is displayed, every conditional format formula is evaluated at each calculation and when the display of the cell that contains the conditional format is refreshed. The Excel object model has a Worksheet.EnableFormatConditionsCalculation property so that you can enable or disable the calculation of conditional formats.
Excel performance - Tips for optimizing performance obstructions | Microsoft Learn
The above article pre-dates dynamic arrays but has some good information.
- You're welcome!
