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?





RE: Formula Auditing
Is this any use?
----------------------------------
Hope this helps.
----------------------------------
maybe only a drafter
but the best user at this company!
RE: Formula Auditing
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.
RE: Formula Auditing
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
RE: Formula Auditing
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.