Article 43 - Optimize, Troubleshoot and Improve Performance in Excel (non VBA)

By |Friday, November 18th, 2016|Categories: Articles|Tags: , , , , , , , |0 Comments

Below points will help you in following to optimize your excel sheet

  1. Reduce time taken to calculate / recalculate
  2. Reduce time taken to open / close workbook
  3. 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”.

(more…)