Trace Dependents PLUS

BallGazer

Board Regular
Joined
Jul 16, 2008
Messages
110
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-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
BallGazer.<o:p></o:p>
 
Last edited:

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,493
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,241
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top