Trace Formula Calculations

xlCompare gives you unique feature: drill-down tracing of the calculation results.

With this feature you don't need to use Trace Dependents feature anymore!

Select cell you want to research and apply Tools | Evaluate Formula command:

One second and you have the results:

You can expand cell values untill inputs (constant cells).

This feature is present only in xlCompare. Do you see red arrow icon? This is a return value of the OFFSET function. OFFSET refers to cell\range depending on its arguments. On this place you can stop if you are using Trace Dependents command in Excel.

xlCompare not only shows you reference returned by OFFSET, but also allows to trace it right here!

This extremely useful feature allows you to find out where result of the formula came from!