how do trace dependents for all cells at once?

[Guest]

Thanks for any help.
I want to trace all dependents in a worksheet at once-is that possible?
I have a large worksheet, and it would take a long time to go to cell by
cell to trace dependents.
Thanks.

 

[Guest]

AFAIK you can only trace dependents for the Active Cell (or 1 cell at a
time). It may be time consuming, but just imagine how confusing it would be
to have possibly hundreds (maybe thousands) of arrows & rectangles suddenly
overlapping one another. IMHO, that would be even worse.

One thing that may expedite the task... Go to Edit>GoTo, click 'Special' &
choose Formulas (uncheck any boxes if appropriate). You can then click the
Trace Precedents button on the Formula Editing toolbar to still trace only
one cell at a time, but then you can just press Tab afterward to go directly
to the next cell to be traced.

HTH |:>)

 

[Jim Cone]

Ian,

There is some code of mine here that might do what you want...

http://makeashorterlink.com/?L5F24173B

' Finds worksheet formulas on each sheet in the active workbook.
'Adds a new worksheet and lists all formulas found and their cell addresses,
' values, precedents and dependents.
' Formulas that have error values will also appear on the list.

Regards,
Jim Cone
San Francisco, USA


Thanks for any help.
I want to trace all dependents in a worksheet at once-is that possible?
I have a large worksheet, and it would take a long time to go to cell by
cell to trace dependents.
Thanks.

 

[Guest]

Hallo,
Sorry, for for the late answer but I just saw your post yesterday, when this
problem came up to me too.
The solution is easy in Excel 2003:
Select any empty cell
Type "="
Click on the upleft corner of your worksheet to select all the cells.
Usually next to "=" will be written 1:65536
Then press ENTER.
Excel will complain ciclular reference.
Click on OK.
Select the cell were is written the above.
Double click on the button "Trace Precedents"
Ups!!! Here are all the arrows!!

 

[Guest]

Jim,
I just ran across your code here and it works great! However, I need it
to show the dependents from the whole workbook not just the current sheet.
In otherwords is there something I can modify in your code to show in the
dependent column all of the dependents within the entire workbook? i.e. a
cell in another sheet that references a cell in the current sheet. Thanks in
advance!