This command is only available via the Technical Support toolbar, which can be activated via the Advanced section of the Preferences window.When tracing is active, Office Connector maintains statistics on operations that are executed. This information can be gleaned from the trace log, but the Dump Call Stack Trace command makes it much easier to do. Dumping the call stack trace to Excel also erases it from memory, effectively resetting the counters. This makes it convenient to see everything that happens in response to a specific action you take.
The Grid
When you click the button, a new worksheet is inserted into your workbook and a formatted table is populated with the statistical data. The rows appear in the order that the operations were executed, except that if an operation occurs multiple times, the additional instances will be represented in the initial row. The columns are explained below:Instances
This is a counter that indicates how many times a particular operation has been executed with the associated combination of parameters.Cell
If the operation was a workbook function, this will indicate the function's cell address. For operations where cell addresses do not apply, unknown will be listed.Operation
The name of the command or workbook function.Stack Depth
Indicates the number of items on the call stack when the operation executed. When an operation starts the sequence of events, the stack depth will be 1. If another operation is triggered while the first operation is pending, then the stack depth will be 2. Normally this number does not exceed 2.Param 1 … Param 6
These columns list the parameters that were passed to workbook functions.