How to trace dependents in a book at once without checking cell by
 

In the Links menu is possible to know all workbooks on wich the active
workbook depends on. Is it possible to know all the workbooks that depends on
the active workbook, the opposite thing?

Alisfalor wrote:
In the Links menu is possible to know all workbooks on wich the active
workbook depends on. Is it possible to know all the workbooks that depends on
the active workbook, the opposite thing?


No.
But you could write a macro to search all workbooks in a directory structure to
find those which contain a link to the workbook in question.
Come to think of it, I already did - my LinkManager would do this for you.
If you want a copy, EMail me at Bill_Manville @ compuserve.com (without the
spaces).

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

I have tried sending LinkManager to you by email but all messages are
being refused:

<<
A message that you sent could not be delivered to all of its
recipients. The following address(es) failed:


SMTP error from remote mailer after RCPT
:
host cnbvmail.cnbv.gob.mx [200.76.25.210]: 550 Rule imposed mailbox
access for refused


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup