Share via

How to find off-sheet traced dependency?

Anonymous
2012-01-06T19:33:58+00:00

When I do Trace Dependent, I get an off-sheet depency like this:

How do I find the dependent cell off-sheet?

For this example, the off-sheet reference is the formula =VLOOKUP(1,Sheet1!A:C,2,0).  So I cannot use Find All, searching for B1.

(Don't be misled by the simplicity of this abstracted example.  The off-sheet reference appears in a workbook that I am not familiar with.  It has a dozen worksheets and 100s or 1000s of cells per worksheet.)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2012-01-06T22:20:32+00:00

    Double-click the dotted line to open the GoTo dialog.

    For more control, you might have a look at RefTreeAnalyser by Jan Karel Pieterse (not free, but demo version available).

    2 people found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2012-01-06T22:37:21+00:00

    The mouse pointer changes to a north-west arrow when it is over the area where you can double-click. But I agree that it is easy to miss the target... :)

    0 comments No comments
  2. Anonymous
    2012-01-06T22:29:42+00:00

    Hans wrote:

    Double-click the dotted line to open the GoTo dialog.

    Great!  Thanks.  Sigh, I tried that myself, but I guess I'm not very good at pointing ;-).

    0 comments No comments