Formula Auditing 1

[Clyde38]

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?

 

[onlyadrafter]

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!

 

[Clyde38]

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.

 

[Kwan]

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.

 

[Kwan]

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.

 

[Clyde38]

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.