Home

best practice for multi-window tracing of precendents and dependents

txrussianguy
Contributor

I need some help with the best way to trace precedents and dependents in a multi-window setup.  Specifically, I have always used multiple windows when trying to audit formulas, but have always found annoying the fact that while in a single sheet, I can go into my formula bar and see the color highlighting in the various cells the drive it. I can also use the formula auditing lines for precedents and dependents.  When I'm dealing with a source or destination in another sheet, two annoyances occur (which have their merit in some ways, but they are not as convenient as the same-sheet options):

 

1) if I click into a cell, any corresponding window that is open, which has the source or destination, does NOT color any differently (therefore not indicating the relationship)

2) using the precedent and dependent arrows does NOT impact the additional window

 

Is there a way to interactively use multiple windows to trace things, so that I don't have to keep hopping back/forth between sheet tabs?

 

Thanks for any thoughts.

1 Reply

I'm afraid not. You may find my RefTreeAnalyser useful though. It has a Visualize button that has most of the functionality you need. The tool offers a free demo mode: https://jkp-ads.com/reftreeanalyser.asp

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies