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.

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

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