Trace Calculations enables you to debug a calculation step-by-step through each cell—you can eliminate common modeling errors and optimize processing times.

Looping errors often occur in complex models, causing unnecessary calculations. Trace Calculations calculates and displays the model, using color codes to show the start and end points of problematic loops:

Double-click the start of the loop (green) to move to the next cell–double-click on each successive cell to get to the next. You hover the mouse pointer over cells to display the calculation in a tooltip.