TRACE function

This article describes the formula syntax of the TRACE function


Alert when a cell is evaluated in a calculation.



ref is a reference to a cell to trace.

The TRACE(ref) function displays a popup dialog when the cell being referenced is evaluated during a calculation. The dialog displays the name of the cell reference in A1 format, the formula in the cell that is being evaluated, and the current contents of the cell.