Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How can I trace dependents across worksheets?
Suppose I have a cell with the name Foo in Sheet2, and I reference Foo in Sheet1. When I go to Sheet2 and select Trace Dependents under Tools / Formula Auditing), Excel shows an arrow to an icon that resembles a spreadsheet. But I have not found a way to expand the icon into a cell reference or even to identify the worksheet. Moreover, if I visit each worksheet, I do not automatically see off-sheet arrows to those dependent cells. (Note: Show All is selected under Tools / Options / View. I am using Excel 2003 rev 11.6355.6360 SP1 with Win XP Pro SP2.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
trace dependents | Excel Worksheet Functions | |||
turning off trace dependents error message | Setting up and Configuration of Excel | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
How to trace dependents in a book at once without checking cell by | Links and Linking in Excel | |||
Tracing Dependents | Excel Discussion (Misc queries) |