View Single Post
  #1   Report Post  
Graham Tapper
 
Posts: n/a
Default Trace ALL dependent cells in any worksheet anywhere in Excel

Would like ability to be able to trace all the dependent cells, on whatever
worksheet they appear, anywhere within a spreadsheet. Currently Excel will
not trace Text cell references or references to cells on other worksheets.
All it does is point an arrow to a picture of a worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the worksheet(s).