• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2007 Trace Dependents question

F

fred

Member
I'm facing a workbook with 50+ worksheets with a ton of links across all the worksheets. So when I want to find out what one cell have affect other cells on the same worksheet and other worksheets I used "Trace Dependents".


The question I have is that I see a picture of a tiny worksheet thing but I can't click it and it goes to the worksheets this cell has effect on. What can I do? How do I tell which worksheet and what cells it goes to next?


Any advise is greatly appreciated.
 
Thanks Narayank991. I ended up moving the formula and consolidated it with other formula under one worksheet. Then delete the original ones. So far I don't see anything out of place. So I guess it is fine.


There are just way too many background formula running behind so many worksheets when they can be easily managed under one worksheet with explanation.


Thank you once again!


just on the side note, the "trace dependents" were pointing to itself when I double click on the arrow! Can you believe that?
 
Hi Fred ,


Nice to know that things are OK.


If the arrow points to itself , shouldn't there be a circular reference ?


Narayan
 
hi Narayank991.


Excel didn't show up any circular notice on the screen (lower left) or any pop up window. /shrug
 
You must log in or register to reply here.
Back
Top