how can I find out trace dependents on other pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 17 Dec 2006 00:26 GMT

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

Signature

PETER

Reply to this Message

Max - 17 Dec 2006 08:25 GMT

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)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

Peter - 17 Dec 2006 11:13 GMT

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?

Signature

PETER

> 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)
> >I want to find out trace dependents, how can I find out trace dependents on
> > other pages?

Reply to this Message

Max - 17 Dec 2006 11:32 GMT

> .. 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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> thanks for the hint! I did it as you said :
> 1) now a window pops up "Go To"
[quoted text clipped - 4 lines]
> connection
> is a lookup?

Reply to this Message