how can I find out trace dependents on other pages

[Peter]

I want to find out trace dependents, how can I find out trace dependents on
other pages?

 

[Max]

After clicking Tools > Formula Auditing > Trace Precedents/Dependents, if
you were to double-click on the dotted arrow that points to a mini sheet
icon, that'll bring up a "Go To" dialog to navigate to either the
precedent(s) / dependent(s)

 

[Peter]

thanks for the hint! I did it as you said :
1) now a window pops up "Go To"
2) in the Go to Windows I can select many fields
3) it also offers a "special"-button

I have tried a simple connection, this works, but what happens if the
connection
is a lookup?

 

[Max]

.. but what happens if the connection is a lookup?

Above works ok for me here (just tested on an INDEX/MATCH formula which
looks up another sheet), unless I'm not reading you right ?

Albeit the longish links displayed within the "Go to" box appeared truncated
(the "Go to" box is not scrollable), you can select each link, then use the
"Reference" box to scroll & view the entire link (just click inside the
"Reference" box, then press End to zip rightmost). Clicking OK zapped me
straight to the other sheet with the column highlighted