View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default How do you ID cell precendents/dependents in other sheets?

There should be an arrow pointing to a worksheet icon. When you double click
on the icon (for me it only works when double clicking on the bottom of the
icon, right when the cursor changes from a + to an arrow), it should open up
the goto dialog box with a listing of the external links. You can select a
link from this dialog and XL will take you to it.

" wrote:

The arrows displayed by Tools / Formula Auditing / Trace Precedents/
Dependents point to a formula's precedent/dependent cells in the SAME
SHEET as the formula only.

Precedents/dependents in other sheets in the workbook are not
identified.

Doesn't Excel have a 100% functional auditing mode or dialog?

(Or, have I failed to install a Valu-Pak or add-in?)

Thanks much.

***