×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Formula Auditing

Formula Auditing

Formula Auditing

(OP)
When using the "Formula Auditing" feature, it is easy to determine the precedent or the dependent if either is on the same sheet (indicated by an arrow).  If the referenced cell (dependent) is not on the active worksheet, a small spreadsheet icon appears to indicate that the "Trace Dependents" are somewhere else.  Is there an easy way to determine the location of the dependents?
 
ponder

RE: Formula Auditing

One way, although not very helpful, is to use the EDIT --> LINKS, you can then enter the directory into the search function, and it will locate the cells with references to other workbooks.

Is this any use?

----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

RE: Formula Auditing

(OP)
Thanks Only... But The Best,

I’m familiar with this feature.  However, I’m referring to the references within a workbook or even the same sheet.  If the “Trace Dependents or Precedents” are on the same sheet the arrow provided by the auditing feature points directly to the cell (s) in question.  When the reference goes beyond the same sheet, the arrow points to a spreadsheet icon.  It seems that you should be able to click on the icon and find the cells referenced.  This is not the case.

noevil

RE: Formula Auditing

I think the formula audit function is good.  I use it all the time.  When you place your mouse pointer over the dashed line (between the cell and the icon of the worksheet) the pointer will change to the default.  Now just double click and a window should appear indicating the location of the precedent/dependent.

I would like to see this reference appear automatically.  It would make life easier.  Perhaps someone knows if excel can show these automatically?

Hope this helps.

RE: Formula Auditing

I found a couple other methods.  Highlite the cell of interest and then click evaluate formula from the audit toolbar. Another method is add a watch (within audit toolbar).  In the watch window you can see the cell's prec/depend.

RE: Formula Auditing

(OP)
Kwan,
I've used the "evaluate formula" and it works fine for precedents but actually evaluates the formula for dependents.  The double click on the dashed line is what I was looking for.  Thanks for the help.

thumbsup2

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources