Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
a formula which calculates empty cells | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) |