Though I can't seem to find it, at one point, I learned that EXCEL cannot trace dependents if those dependencies are within the argument of certain EXCEL worksheet functions such as "offset", and a few others. After expressing surprise, some expert later confirmed this.

Today, I am, potentially (though I doubt it) seeing similar behavior with the Cell function, however since it is the W86 cell reference below that says it has no dependents, I don't think that the cell function should matter.

=IF(CELL("TYPE",Override!W45)="V",Override!W45,'Se lling & Marketing'!W86/1000)

Do you agree that the cell function should be incidental to this problem, since the worksheet cell in question (W86) is part of the if statement, not the cell function? Or can just having the cell function mixed in there, within the same IF statement, cause EXCEL to not realize the dependency.

What other things can cause the trace dependents to miss finding a dependent (on another worksheet)? By the way, when I do a trace precedents on the cell that is obviously dependent on this cell, it does show up as being its precedent.

Thanks!
Dean