Below points will help you in following to optimize your excel sheet
- Reduce time taken to calculate / recalculate
- Reduce time taken to open / close workbook
- Reduce file size
Below points may not be valid in many circumstances so you will have to see the suitability of a recommendation but most of the time, these will be valid. Also, in this article we would not concentrate on “WHY” but “WHAT”.