#1   Report Post  
JBoulton
 
Posts: n/a
Default trace dependents

Tools/Formula Auditing/Trace Dependents produces a dotted line with an arrow
to a sheet icon. How do I find which workbook/worksheet has the dependent?
--
Jim
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

Double click on the dotted line

"JBoulton" wrote:

Tools/Formula Auditing/Trace Dependents produces a dotted line with an arrow
to a sheet icon. How do I find which workbook/worksheet has the dependent?
--
Jim

  #3   Report Post  
JBoulton
 
Posts: n/a
Default

That was too easy! Thanks for the hint.
--
Jim


"Duke Carey" wrote:

Double click on the dotted line

"JBoulton" wrote:

Tools/Formula Auditing/Trace Dependents produces a dotted line with an arrow
to a sheet icon. How do I find which workbook/worksheet has the dependent?
--
Jim

Reply
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 Dependants NICK Excel Discussion (Misc queries) 0 May 18th 05 08:16 AM
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 08:53 AM
Tracing Dependents adamcal2004 Excel Discussion (Misc queries) 0 December 15th 04 09:21 PM


All times are GMT +1. The time now is 02:20 PM.

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

About Us

"It's about Microsoft Excel"