Formula Auditing: Observing the Dependent Cells in Another Window
 

Hi,

My question is about how to observe the location of dependent cells (Trace
Dependents/Trace Precedents) in different windows. In other words, using
Formula Auditing Toolbar I would like to view the dependent cell of the
another sheet in a new window I created.

To accomplish this, I am using the Book1 workbook which has multiple
sheets. Then, I created Book1:2 (by WindowNew Window) so that I now have
two windows ( Book1:1 and Book1:2). Then, I arranged them ( by
WindowArranceHorizontal) so that I can view both all at the same time.

My active window is Book1:1 and I have selected a cell in one of the sheet
in this window and would like to see the dependent cell in another sheet
(Trace Dependents in Auditing Toobar). However, when I double-clicked the
line which indicates that it has values in other sheet it shows the dependent
cell in another sheet in the Book1:1. In other words, Book1:1 window goes to
another sheet. I do not want this, I want Book1:2 show the sheet which has
the dependent cell.

Is there any way that Book1:1 does not change its sheet, i.e., has the same
view but the dependent cell is now shown in Book1:2 window. This sometimes
happens, sometimes does not??

Thanks.



When I click the window_1