Trace Dependents PLUS

[BallGazer]

Does anyone know of a "trace dependents" option which will track all 'downstream' dependents for a particular cell? I am trying to debug a complex workbook where cause and effect can be separated by about 10 hops/sheets. I appreciate that this can be a long list and follow many different legs. However, clicking on each dependent cell is tedious. Of course this could just be my lack of basic excel knowledge. Any help appreciated.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
BallGazer.<o></o>

 

[al_b_cnu]

Hi,

There is Tools/Formula Auditing/ Trace Precedents
or Tools/Formula Auditing/ Trace Dependents

It will only trace the current cell, but it's a start

 

[DonkeyOte]

Not sure if this is of use to you but a user here has compiled a tool which Andrew rates and if he rates it it should be good !

http://www.mrexcel.com/forum/showthread.php?t=338332