LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default How to trace dependents across worksheets?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
trace dependents JBoulton Excel Worksheet Functions 2 May 19th 05 09:04 PM
turning off trace dependents error message D Griffith Setting up and Configuration of Excel 0 May 3rd 05 05:51 PM
Trace Dependents and Precedents not working Manish Excel Worksheet Functions 0 April 11th 05 09:39 PM
How to trace dependents in a book at once without checking cell by alisfalor Links and Linking in Excel 2 March 11th 05 07:53 AM
Tracing Dependents adamcal2004 Excel Discussion (Misc queries) 0 December 15th 04 08:21 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"