View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
happy 111 happy 111 is offline
external usenet poster
 
Posts: 4
Default Trace Dependent - off worksheet page reference

when using the 'formula auditing' toolbar 'trace dependent' button and the
'other worksheet' icon comes up to indicate a cell/s on another worksheet are
dependent upon the cell chosen, does anyone know how to find the dependent
cells on the other worksheets?? Knowing there is a dependent cell on another
sheet (without knowing where it is) is tormenting :(

thanks in advance. Peter