Auditing Dependent Cells

[WildBill]

In older versions of Excel, I used to be able to audit a dependent cell to show all of the cells that it used to determine its value. Alternatively, I could audit a cell to determine what other cells used it as a factor in their calculations.



This auditing function seems to be gone from Excel 2010. Anybody know how to perform thet function now?

Thanks in advance for any help.

[Catalin.B]

this option is in excel 2007 too...
http://www.addictivetips.com/microso...ts-dependents/

[WildBill]

Thanks, I can't believe I couldn't find it. It was exactly where it should have been.