Forum Discussion

Mike Clark's avatar
Mike Clark
Copper Contributor
Jun 15, 2017

Testing Excel 2016 performance

Does anyone know of any tools/applications that can be used to test the performance over time of Excel responsiveness?   running macros, linked books etc.   Want to gather empirical data to allow management to make better decisions in one of our offices, in what version of office, 32 bit or 64 bit, with various memeory configurations. 

  • Check out Charles Williams' site DecisionModels. He has lots of free code to run speed and performance tests against workbooks.

     

    If you don't want to stitch it all together yourself, you can purchase his Fast Excel add-in which has a lot of functionality to identify performance issues and do speed tests.

     

    http://www.decisionmodels.com/fastexcel.htm

Resources