Speed Testing Workbooks

[squiggler47]

The microtimer routine was taken from the MSDN Site http://msdn.microsoft.com/en-us/library/aa730921.aspx in an article by Charles Williams

I use this code a lot when testing workbooks to time functions, hope it is of some use to you!


it provides a macro

TimeSheet

Which will produce a new worksheet with timings of all formulas found in the active sheet, sorted slowest first!

and 2 functions

TimeCell(Cell,iterations)

This will return the time it took to calculate that formula note the more iterations the more acurate!

FormulaIs(Cell)

Just so I can see the formula!

Please Login or Register  to view this content.

[JiaChiao]

This is big help to me while I am wondering if the Named Reference and Named Fomula will slow the Excel. With this Speed Testing Workbook, I found the goodies and trade-off of the Naming.
I have a lab workbook for whoever will be interested in my test result.